X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A38705342B; Mon, 4 Apr 2005 14:43:56 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13828-05; Mon, 4 Apr 2005 13:43:39 +0000 (GMT) Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244]) by svr1.postgresql.org (Postfix) with ESMTP id 168FF53400; Mon, 4 Apr 2005 14:43:38 +0100 (BST) Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R) with ESMTP id md50000576091.msg; Mon, 04 Apr 2005 06:44:00 -0700 Reply-To: From: "Dinesh Pandey" To: , Subject: Migrated Oracle database to PostgreSQL ?? Date: Mon, 4 Apr 2005 19:11:17 +0530 Organization: Second Foundation India P Ltd. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0025_01C5394A.164E71D0" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 thread-index: AcU5G/olnBFaDt3uQp2kxh5qQtybyg== X-Authenticated-Sender: dpandey@secf.com X-Spam-Processed: mail.secf.com, Mon, 04 Apr 2005 06:44:00 -0700 (not processed: message from valid local sender) X-MDRemoteIP: 220.227.32.11 X-Return-Path: dpandey@secf.com X-MDAV-Processed: mail.secf.com, Mon, 04 Apr 2005 06:44:01 -0700 Message-Id: <20050404134338.168FF53400@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.47 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID X-Spam-Level: * X-Archive-Number: 200504/46 X-Sequence-Number: 20939 This is a multi-part message in MIME format. ------=_NextPart_000_0025_01C5394A.164E71D0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi there, Has anyone migrated Oracle database to PostgreSQL? If yes, could you please help me - 1. How to migrate Procedures and Packages from Oracle to PostgreSQL???? 2. How to find error messages in PostgreSQL thrown from an Exception (as we can get messages in Oracle with "SQLERRM" keyword) for example -- --Raise an exception RAISE EXCEPTION 'No Data found for record id % ' ,recordid --Insert exception messages into database EXCEPTION IF RAISE_EXCEPTION THEN -- my_insert_function(SQLERRM); Thanks in advance. Regards Dinesh Pandey ------=_NextPart_000_0025_01C5394A.164E71D0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi there,

Has anyone = migrated=20 Oracle database to PostgreSQL? If yes, could you please help me=20 -

1.=20 How to migrate Procedures and = Packages=20 from Oracle to PostgreSQL????

2.=20 How to find error messages in PostgreSQL thrown from an Exception (as we = can get=20 messages in Oracle with "SQLERRM"=20 keyword)

for example=20 --

--Raise an=20 exception

RAISE EXCEPTION 'No Data = found for=20 record id % ' ,recordid

--Insert exception messages into=20 database

=20 EXCEPTION

IF = RAISE_EXCEPTION THEN

-- &n= bsp; =20 my_insert_function(SQLERRM);

Thanks in=20 advance.

Regards
Dinesh Pandey

------=_NextPart_000_0025_01C5394A.164E71D0--