Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Capture output from Oracle Procedure


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

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

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

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...