Page 1 of 1

Execute Procedure

Posted: Thu Nov 05, 2015 6:18 pm
by D4vidrim
Hi all,
I'dl like to use revExecuteSQL to execute an Oracle Procedure:

my procedure is

UPD_DAV(4,'test4');

So I usually call it like this (on SQL DEVELOPER):

Begin
UPD_DAV(4,'test4');
End;

Therefore on LiveCode I was assuming to write:

revExecuteSQL databaseid, "UPD_DAV(4,'test4')"

But it doesn't work, while a statement like
revExecuteSQL databaseid, "CREATE TABLE ABC (FIELDS...)"
is executed without any problem.

Is there a way to execute procedures?

Thank you!

Re: Execute Procedure

Posted: Fri Nov 06, 2015 1:49 pm
by MaxV
Try:

Code: Select all

put "BEGIN" & Cr &   "UPD_DAV(4,'test4')" & Cr &  "END;" into tSQL
revExecuteSQL databaseid, tSQL