Home » RDBMS Server » Server Administration » Package - REF CURSORS.. with parameters procedures
Package - REF CURSORS.. with parameters procedures [message #369862] Fri, 27 October 2000 14:01
Hari
Messages: 59
Registered: August 2000
Member
want a package
witha procedure which has two cursors, the rows from first cursors is parameter for second cursors and the out parameter of parameter is cursor...
can someone write a sample code for me...
Package...
cursor1;
cursor2;
procedure(in char,out cursor2%rowtype);
end
package body
procedure p1(in cursor1.%type,out ?)
?

?

?
end procedure p1;
end package
Previous Topic: Decode statement
Next Topic: Does trunc slow down performance
Goto Forum:
  


Current Time: Sat Apr 27 01:01:22 CDT 2024