Global place to get OracleError

[Martin Gruber]

Hi, i need have a global place to get OracleError, i now that exist event onOracleError, but i need to know, which oracle object (tOracleDataSet, TOracelQuery) is create error. I don't know how ?

Thanks Martin.

 

[Marco Kalter]

The OnOracleError hook has an EOracleError parameter, which has an Instance property that is the object that caused the error. The help file includes an example for this.

 

[Martin Gruber]

But the INSTANCE is not the TOracleDataset(INSTANCE ) or TOracleQuery(INSTANCE).

Martin

 

[Marco Kalter]

The TOracleDataSet uses a TOracleQuery internally, and this is what you will see in the Instance property.

 

[Martin Gruber]

but when i want read TOracleDataSet(Error.Instance).ErrorLine a get Exception.
Martin

 

[Marco Kalter]

That's right, it will never be a TOracleDataSet. It can be TOracleQuery, TOracleObject, TLOBLocator, and so on. You first need to check the instance type, like in the example in the help file.

 

[Martin Gruber]

ok, and exist some way, to get information about error (errol line, error position, SQL) on TOracledDataset ?

 

[Marco Kalter]

Yes, the TOracleQuery instance has an ErrorLine and ErrorPosition property, and of course a SQL property.