Migrated Oracle database to PostgreSQL ??

From: "Dinesh Pandey" <dpandey(at)secf(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-bugs-owner(at)postgresql(dot)org>
Subject: Migrated Oracle database to PostgreSQL ??
Date: 2005-04-04 13:41:17
Message-ID: 20050404134338.168FF53400@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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


Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Yasir Malik 2005-04-04 19:35:57 Re: Migrated Oracle database to PostgreSQL ??
Previous Message lucas 2005-04-04 13:01:02 Chield Serial