Devart Forums

hi. i want to execute a script which calls several stored procedures, but to continue if one of them fails. In torascript.onerror i set Action := eaContinue, but rest of the statements does not work. What am i doing wrong?
my script is like

begin
p_insert(1, 'abc', 2);
p_insert(2, 'abc', 2);
p_insert(3, 'abc', 2);
end;

You should not use BEGIN and END in the text of the script. TOraScript component considers BEGIN .. END block as single statement.

thanks for the quick reply.
when i remove begin and end from the script, i take 'Invalid SQL Statement' errors. and also when i try to run it using TOAD, it ignores my script completely.
btw if it has any importance i actually use packages, which i didn't mention in my first post, like

pck_1.p_insert(1, 'abc');
pck_1.p_insert(2, 'abc');
pck_1.p_insert(3, 'abc');

solved, i should have put execute to call a procedure. thanks for your time

not solved
using execute for calling procedures works in TOAD, not in torascript. it gives invalid sql statement. i don't get how two are different.

You can use script like this:

it worked, plash. many thanks.
i was about to search 'procedural option', you saved the time.