Jump to content

Capture output from Oracle Procedure

Uday Jadhav

Recommended Posts

There will be various cases where the output value from Oracle procedure may be necessary to examine after executing the procedure from TDV(may be using pacakged query using CALL). How do we do this

e.g. Oracle procedure :

SQL> desc proc_test_op

PROCEDURE proc_test_op

Argument Name Type In/Out Default

------------------------------ ----------------------- ------ --------


TDV packaged query:


CALL PROC_TEST_OP(vOut); ; -- HereI want vOut to collectthe value from ocount of proc_test_op

select vOut from dual; --and examine the output

Question: How do I declare vOut in TDV. Tried parameter add but couldn't work

Appreciate any suggestions

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...