Possible to use EXEC in TOracleQuery?

[brettf]

Is it possible to use the EXEC command to execute a PL/SQL procedure, stored on the Oracle server, with a TOracleQuery component? My application seems to be hanging when I set the SQL to "EXEC Clear_Tracking" and call the Execute method. Is there a better way?

-- Brett Fattori
Online Technologies Corp.

 

[jpickup]

EXEC is something that is only valid within SQL*Plus. The SQL in your TOracleQuery should rather be of the form:

begin
theprocedure;
end;

 

[brettf]

Thanks for the information.

- Brett Fattori
Online Technologies Corp.