TOracleQuery.Execute and OCI_SUCCESS_WITH_INFO

[Sergey Radionov]

Haw I can check that OCIStmtExecute in TOracleQuery.Execute return OCI_SUCCESS_WITH_INFO?

That need to me for SQL statements like this:
ALTER FUNCTION MYFUNC COMPILE
ie when function compilation falure.

PS: Sorry my terrible English...

 

[al0]

Originally posted by Sergey Radionov:
Haw I can check that OCIStmtExecute in TOracleQuery.Execute return OCI_SUCCESS_WITH_INFO?

That need to me for SQL statements like this:
ALTER FUNCTION MYFUNC COMPILE
ie when function compilation falure.

PS: Sorry my terrible English...

Take a look on WarningFlags property of TQuery, eg

if dmData.oqMisc.WarningFlags and 32)<>0 then
....

For further details see DOA documentation. Note, that for OCI>=8.0 32 is only possible value for this flag.

BTW your English is not much more terrible then my.

 

[Sergey Radionov]

Thank you. It is what I really have been search!