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.
ORACLE execute immediate / PLSQL
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- VIP Livecode Opensource Backer
- Posts: 37
- Joined: Fri Sep 09, 2011 10:04 am
- Location: Netherlands
Re: ORACLE execute immediate / PLSQL
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
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
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode