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

Access Camera HTML 5

Access camera and video, the  INPUT  element with a type of  file  is necessary: < input type = " file " accept = " i...

buy cloth