Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mC0uY-0006Vh-S0 for pgsql-admin@arkaria.postgresql.org; Fri, 06 Aug 2021 14:33:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mC0u1-0004wg-1S for pgsql-admin@arkaria.postgresql.org; Fri, 06 Aug 2021 14:32:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mC0u0-0004wX-Nu for pgsql-admin@lists.postgresql.org; Fri, 06 Aug 2021 14:32:48 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mC0ty-00058M-4N for pgsql-admin@lists.postgresql.org; Fri, 06 Aug 2021 14:32:47 +0000 Received: by mail-wm1-x335.google.com with SMTP id l4-20020a05600c1d04b02902506f89ad2dso7395090wms.1 for ; Fri, 06 Aug 2021 07:32:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=migops.com; s=google; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding:content-language; bh=YujcOMngquRQ4QNDYqX+gCZlYn9ABCq3Zl/B43ev3r8=; b=F9fvwKYhASapWmBOyq13SRKQ6f2g1h1gGAEUAsgK7ax6VqI9bsVLmYMD2LVC+I5iDU HiKesmUoYnbvMySWsQJuj7HbNGWJp0YRv+Ie4SOqbMGdX2xVpIPixL+iN7mbeFT2THUY nYXDcY3PB7eBeChlVfet+O5eJPjv3fk+JercJBCdYUculFTznD9rQ7C8lffbBKaEu8pR FhWDa9WmWt9vpZhYm6BE4HIsTdNeVzpvHtzpJJ6GONl5UcwU48cZFvC36W3Zr18jIBqc 960zWVrVaqDczhb3Fjt+4OjjhyAd0t0cqX1WtXqHaFoTtQvnsqVTyWFmCcy0IrKvice5 rW9A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=YujcOMngquRQ4QNDYqX+gCZlYn9ABCq3Zl/B43ev3r8=; b=jW4WII6N1wKUgvrfKMgY/vW0pytaa9PhZH9dd+78mIJg7+WCmUQfjc3IbfsdBTtvYu pAlb6zyX5cVOP/9NYcfwwfJ3BZC1kPujDWh2IRlWSGVMQf1jvgateAVh/9uADu77eA0A ZSHzYRKx3ofdYqn1HRshNcyRXadAI9zkVlxYFAUtz3DWJbDoMx5Ol4ib9IyzqeNsojSt brh8p6hhLZGSikdoYXryewSnhQHRA3pHd9FKE/To0McD/C+vB/XeRxlYZEEwiJD9rEIb q7hn0BAuMARA69dC6lfl8lfOU4Y17cD9iDe9SM0EVR8odlUJKPyKtHcEIsbjdovuoVkr W52A== X-Gm-Message-State: AOAM5306rOHLXd+49o/uwo81K3amyqtDPskuEZoIW+7dAc+qlqAw3Q3R u69JrF4L8HJeRl9/5QgBL+HyxIV1CdeZxXYc X-Google-Smtp-Source: ABdhPJycZnum/7BT18bC0tCFIhnlEaSBOvAQ3OCYq+U7tS9M1bZESs5NEvNSs0jqtFqgwDO5ea3+xQ== X-Received: by 2002:a05:600c:2159:: with SMTP id v25mr3745649wml.42.1628260363813; Fri, 06 Aug 2021 07:32:43 -0700 (PDT) Received: from ?IPv6:2a01:cb14:51d:5100:f5b8:d5ef:4350:ecba? ([2a01:cb14:51d:5100:f5b8:d5ef:4350:ecba]) by smtp.gmail.com with ESMTPSA id f74sm8936018wmf.16.2021.08.06.07.32.42 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 06 Aug 2021 07:32:43 -0700 (PDT) Subject: Re: Oracle error log table equivalent in postgresql To: Mukesh Rajpurohit , Pgsql-admin References: From: Gilles Darold Message-ID: <9e116fec-7756-5fd5-f537-a4fc771d7603@migops.com> Date: Fri, 6 Aug 2021 16:32:41 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Maybe this implementation [1] of Oracle DBMS_ERRLOG for PostgreSQL could correspond to what you are looking for. [1] https://github.com/MigOpsRepos/pg_dbms_errlog Best regards, -- Gilles Darold MigOps Inc http://www.migops.com/ Le 06/08/2021 à 13:35, Mukesh Rajpurohit a écrit : > 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. > > Thank you in advance, > Mukesh -- Gilles Darold