Execute Procedure

[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!

[MaxV]

Try:

Code: Select all

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