| From: | "Dinesh Pandey" <dpandey(at)secf(dot)com> |
|---|---|
| To: | <pgsql-patches(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Exception handling: Oracle's "SQLERRM" keyword option? |
| Date: | 2005-04-18 05:16:35 |
| Message-ID: | 20050418052030.9C1E0534A3@svr1.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
Hi,
I have installed PostgreSQL 8.0.1 on Solaris 9.
I am porting my database from Oracle 9i to PostgreSQL. I am using PL/pgSQL
language.
In Oracle we can get error message from "SQLERRM" keyword and insert
messages into log table.
How can I get error message/error code in PostgreSQL after an EXCEPTION or
RAISE EXCEPTION occurs in EXCEPTION block??
Pls help me or send me some example.
Thanks
Dinesh Pandey
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-04-18 05:42:06 | Re: [PATCHES] Exception handling: Oracle's "SQLERRM" keyword option? |
| Previous Message | Dinesh Pandey | 2005-04-18 05:06:27 | How to include "EXCEPTION" handling block in PL/TCL function. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-04-18 05:42:06 | Re: [PATCHES] Exception handling: Oracle's "SQLERRM" keyword option? |
| Previous Message | Dinesh Pandey | 2005-04-18 05:06:27 | How to include "EXCEPTION" handling block in PL/TCL function. |