CURSOR AND INPUT VARIABLE

[balajiyes]

hi :)
i want to concat my IN variable inval to a CURSOR

the value of the inval will be ' select * from emp where deptno = 10 '

i will this inval to concat with the CURSOR @ the declaration part

create or replace procedure test_formstr(inval in varchar2,outval out varchar2) as
a varcahr2(100);
cursor c1 is inval;
begin
dbms_output.put_line(a);
valoutab := 1;
end;

is this POSSIBLE?
plsss
write back @ balajiyes@yahoo.com or jegannathans@yahoo.com
jegan

[sasmita]

Please go and check Oracle Developer, some body has already given you your required answer.

[Highlander]

Look into ref cursors