-
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
Cheers!
OraKid.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|