Can TOracleScript replace sql*plus ?

[kuzkot]

Hi,

I would like to run scripts withtin a Delphi program.
We usually run those scripts with sql*plus, but it lacks a proper command line support, in particular error handling and reporting.

So I plan to use TOracleScript instead of calling sql*plus from the command line, but I wonder if any of you have successfully used this component *and* if there are some limitations to it (i.e. any script executed with the component will produce the same output than sql*plus ?)

Thanks
Kuzkot

 

[Marco Kalter]

The TOracleScript is not designed for SQL*Plus compatibility. It is designed to exectue batch scripts with multiple SQL statements and PL/SQL blocks. It offers error handling through the OnError event handler.

You can extend the TOracleScript command functionality through the OnCommand event handler.

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

 

[kuzkot]

Thanks for the answer.