Date: Fri, 6 Aug 2021 14:22:52 +0200 (CEST)
From: 066ce286@free.fr
To: Mukesh Rajpurohit <vivasvan1902@gmail.com>,
	Pgsql-admin <pgsql-admin@lists.postgresql.org>
Message-ID: 
 <1988438991.782818247.1628252572604.JavaMail.root@zimbra82-e14.priv.proxad.net>
In-Reply-To: 
 <CAL+ptAAXpddCv1HR90sest4RpD2AHhfoC-5y5eRyZJEr=U9O0g@mail.gmail.com>
Subject: Re: Oracle error log table equivalent in postgresql
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/1988438991.782818247.1628252572604.JavaMail.root%40zimbra82-e14.priv.proxad.net>
Precedence: bulk

> Hi all,
> I am porting oracle procedures into postgresql code and some oracle
> procedure contain error log table and save exception code. I could
> not find any equivalent of it in postgresql.
> 
> 
> Please help if any pointer or lead to its solution.

Something like :

<..>
EXCEPTION
  WHEN OTHERS THEN
    GET STACKED DIAGNOSTICS l_errno=RETURNED_SQLSTATE, l_errtext=MESSAGE_TEXT, l_errctx=PG_EXCEPTION_CONTEXT;
    PERFORM TRACE_ERROR(l_errno,l_errtext,l_errctx );
    RAISE EXCEPTION 'ERREUR %\n%\n%\nStackTrace : %',l_errno,l_errtext,l_errctx;
END;
$$ LANGUAGE PLPGSQL;


??