Capture output from Oracle Procedure

[Uday Jadhav]

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

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

OCOUNT NUMBER OUT

TDV packaged query:

multipartseparator=;+;

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