Sep.06
How to run Procedure directly from Toad to get cursor result
Sometimes we need to check procedure out put in fast manner without implemented by server side script.
This will show result in Data Grid by calling Procedure with its in put and out put parameter.
Here is example of Cursor Out put Procedure which will show the customer detail information.
CPR_GET_BPC_CLIENT_INFO is procedure name
<10> is first input parameter
<1010011003660524> is second input parameter
<‘A’> is third input parameter
<‘X’> is the fourth output parameter with cursor type
VARIABLE X REFCURSOR;
EXEC CPR_GET_BPC_CLIENT_INFO(10,1010011003660524,’A’,:X);
PRINT X;
The real implementation of Php Script to call CPR_GET_BPC_CLIENT_INFO procedure.