Postgres Pro
Downloads
Home   >   mailing lists

Exception handling: Oracle's "SQLERRM" keyword option? - Mailing list pgsql-patches

From Dinesh Pandey
Subject Exception handling: Oracle's "SQLERRM" keyword option?
Date
Msg-id 20050418052030.9C1E0534A3@svr1.postgresql.org
Whole thread Raw
Responses Re: Exception handling: Oracle's "SQLERRM" keyword option?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tree view

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 

 

 

pgsql-patches by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: How to include "EXCEPTION" handling block in PL/TCL function.
Next
From: Tom Lane
Date:
Subject: Re: Exception handling: Oracle's "SQLERRM" keyword option?