CURSOR AND INPUT VARIABLE

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 @ [email protected] or [email protected]
jegan

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

Look into ref cursors