SQLException.getErrorCode and SQLCODE

Question

I have a Oracle procedure, that uses PL/SQL SQLCODE function in EXCEPTION section. Now I need to translate that procedure in Java. I found SQLException.getErrorCode function. Are results of SQLCODE and SQLException.getErrorCode the same? Is there right way to get result of SQLCODE function in Java?

According to the javadocs docs.oracle.com/javase/6/docs/api/java/sql/… Retrieves the vendor-specific exception code for this SQLException object. Try it and see. — Scary Wombat
– Scary Wombat, Commented Oct 4, 2013 at 7:26

Bhushan · Accepted Answer · 2013-10-04 07:35:18Z

3

They are equivalent.

SQLException.getErrorCode(): Retrieves the vendor-specific exception code. (see here) SQLCODE : In an exception handler, the SQLCODE function returns the numeric code of the exception being handled. (see here)

Suppose if you have a query in which you have specified wrong table name. Then you will get 942 instead of ORA-00942, because getErrorCode() returns int.

edited Oct 4, 2013 at 7:35

answered Oct 4, 2013 at 7:27

Bhushan

6,19113 gold badges61 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLException.getErrorCode and SQLCODE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related