EOracleError Errorcode question

[Roeland]

Hi,

When I receive an EOracleError, I found that the Errorcode is positive?

I thought that all the errorcodes of oracle are negative?

So, is this intentional? Should I then look for the absolute or the negative value?

Is this documented somewhere?

Thanks,

Roeland

 

[Marco Kalter]

As far as I know Oracle error code numbers are positive.

 

[Roeland]

When raising an exception in PL/SQL, you have to use a negative value between -20999 and -20000.

raise_application_error(-20000, 'This must be negative');

So I expected a negative Errorcode in DOA.

But regarding your answer I can be sure that they are now always positive in DOA. Maybe you should mention this explicitly in your documentation.

Thank you