Thursday, June 23, 2011

call storeprocedure from sqlplus

var rc refcursor
exec tmp_pkg.get_cmts_by_chasses_corsor(14,:rc)
print rc
note:there are not semicolon(;) at end os statement
14 is input parameter,rc is output parameter as a cursor
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)