Thursday, July 7, 2011

how to call a store procedure and display result in TOAD

if I have store procedure located in a package,I want call it in toad for some test,I can do it like this

exec schema.package.Get_Available_LC_By_ChSeq(338,15,:P_CURSOR)
228 and 15 is input parameter,P_CURSOR is output ref cursor
when click run TOAD will ask for output parameter type ,just choose cursor type.
then output parameter(cursor) will display in Data Grid tab of the TOAD.

No comments:

Post a Comment