Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
No replies
SystemAdmin
SystemAdmin
1883 Posts
ACCEPTED ANSWER

Pinned topic How to give parameters to a DB Store Procedure (Oracle PL/SQL Procedure)

‏2013-02-01T21:40:52Z |
The link "Calling a stored DB procedure in OPL" in the thread http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14800175
don’t work anymore.

I already use stuff like that:

aDummySet from DBRead(CONNEX, 
"BEGIN PROCX(:A,:B);END;"(A, B);


But this is not really elegant since I have to create a dummy variable. I suppose that something else exist to do the same. I try the following and this didn't work:

relScenariosWrite to  DBUpdate (CONNEX, 
"BEGIN PROCX(:A,:B);END;"(A, B);


Thank you in advance,