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.

 

 

 

Share this Story:
  • facebook
  • twitter
  • gplus

Leave a comment

Facebook Comment