Doesn't work 'Show Errors' in OracleScript

[Serge A. Bliznykov]

Dear Marco Kalter!

>help type "show errors" after compiling the package with errors.

Doesn't work 'Show Errors' in OracleScript...
I have tried OnData, Output and so on... Unsuccess.
Is it impossible make by DOA ?

 

[Marco Kalter]

The SQL*Plus command "SHOW ERRORS" is indeed not supported. See the TOracleScript help topic for a list of supported non-sql commands.

To add support for "SHOW ERRORS", you would have to implement an TOracleScript.OnCommand event handler that processes this command.

 

[Serge A. Bliznykov]

First of all huge gratitude for the answer.

It is simple to intercept via OnCommand 'Show Errors'. But how it is possible to receive result of action of a command (the errors's list)?
I shall be very grateful to you, if you specify as it can be made.

 

[Marco Kalter]

In the OnCommand event you can access the previous command:

PrevSQL := Sender.Commands[Sender.CommandIndex - 1].Text;

You will have to parse this SQL text to find the owner and name of the object that was compiled, and query the all_errors view for errors in this object. You can use the AddOutput procedure to write the results to the output.

 

[Serge A. Bliznykov]

Dear Marco Kalter!

Big many thanks.
Thank you very very much!

Your idea is clear.

Tomorrow I will try to realize it.