| Help to use nested name_in function in oracle forms 6i [message #504654] |
Wed, 27 April 2011 02:14  |
eng_amrelhanafy
Messages: 5
Registered: October 2010
Location: Egypt
|
Junior Member |
|
|
I have a for loop cursor , I want to use name in with it .
Example :
Create table a (a1 varchar2(10) , a2 varchar2(10) ) ;
insert into a values ( 'aa' , 'bb');
I have an item that contains the column name , lets say its :col_name which equals 'a1' ;
for i in (select * from a) loop
message('The content of a1 is '||name_in('i.'||name_in('col_name')));
end loop;
the message appears ----> The content of a1 is a1
the outer name in function doesn't work , the inner one works well.
Is this function not working with cursors , and is there is any alternative solutions for the previous case ??
Thank you
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
