Monday, November 24, 2014

Oracle toad execute the store procedure

toad  you  directly execute the store Procedure . in this example i have executed the store procedure "GetFormRightsByUser"  
P_USER_ID input parameter AND p_recordset  OUTPUT REF_CURSOR .
var r refcursor;
exec GetFormRightsByUser(P_USER_ID => 42, p_recordset => :r);
print r;

No comments:

Post a Comment

http://blogsiteslist.com