SQLCODE in Oracle Equivalent to Postgres

Question

In Oracle,

WHEN OTHERS THEN
  IF SQLCODE = -31011 THEN

How do I convert the above

IF SQLCODE = -31011 THEN to Postgres as SQLCODE = -31011 is not compatible with Postgres

Pavel Stehule · Accepted Answer · 2018-11-07 04:02:41Z

2

PostgreSQL uses "standardized" SQLSTATE codes. You should to find most near code in the table https://www.postgresql.org/docs/current/errcodes-appendix.html.

You should to prefer named exception if it is available (not available for custom exceptions):

WHEN OTHERS THEN
  IF SQLSTATE = '22012' THEN

answered Nov 7, 2018 at 4:02

Pavel Stehule

46.7k6 gold badges104 silver badges103 bronze badges

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

1 Answer 1