Execute Procedure
Posted: Thu Nov 05, 2015 6:18 pm
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!
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!