| Dynamic where clause for static cursor [message #609941] |
Fri, 14 March 2014 06:19 |
 |
shyam vyas
Messages: 1
Registered: March 2014
Location: India
|
Junior Member |
|
|
I have a requirement in which the system should pass a complete where clause at run time to a cursor created in the form.
Pasted below is the sample code. Please suggest.
begin
:text:=' DECODE(''13760'',h.M001,DECODE(''2'',h.LB001,1,0),0)';
for i in (select m001,lb001 from conf_head h where :text='1') loop
message(i.m001) ;
message(i.m001) ;
end loop ;
exception when others then
message(sqlerrm) ;message(sqlerrm) ;
end ;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
