TOracleScript, Stored Procedures, 8i vs. 8, etc, etc, etc....

[damosan]

Short Version Of Tale:

Developed small app which throws data to Oracle 8i. Turns out the production server is 8.0.5.

The code used to batch a ton (under 100) stored procedure calls. One of two stored procedures are called.

Under 8i I used the following text:
call spName('p1', 'p2', p3, 'p4'....);

I'd batch anywhere from 10 to 50 statements at a click and execute them without failure.

Turns out that 8.0.5 doesn't like the CALL mechanism I was using. I then tried to wrap the statements in BEGIN/END blocks but now I get weird errors.

I'm basically looking for the format of SP calls under 8.0.5 which can be used with TOracleScript.

Damond

 

[Marco Kalter]

Use a begin/end and remove the call (which is 8i syntax):

begin
  spName('p1', 'p2', p3, 'p4'....);
  spName('p5', 'p6', p7, 'p8'....);
  -- and so on
end;

------------------
Marco Kalter
Allround Automations

 

[damosan]

Thank you. I managed to find the begin/end stuff in another (non delphi) example somewhere else on the net.

Damond