Topic
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,