torascript onerror

[monoplaz]

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;

[Plash]

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

[monoplaz]

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');

[monoplaz]

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

[monoplaz]

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.

[Plash]

You can use script like this:

Code: Select all

BEGIN
  pck_1.p_insert(1, 'abc');
END;
/

BEGIN
  pck_1.p_insert(2, 'abc'); 
END;
/
 
BEGIN
  pck_1.p_insert(3, 'abc');
END;
/

[monoplaz]

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