LiveCode Forums.

I want to execute plsql package (is an procedure) and it doesn't return a value.
I crashes LIVECODE completly.
BUt the question is can this be done.

This is what I try to do

put "begin callvaluescustomer; end" into tsql
revExecuteSQL databaseid, tsql

Further I have to wait very long.

The packing runs in in oracle.

Hi,

You can't run multiple SQL lines from within LiveCode. This means that you can't have a SQL script starting with "begin" and finishing with "end". From within LiveCode, you can execute only one line at a time. You need a PHP script or a Perl CGI to make this possible.

Kind regards,

Mark