From: Dinesh Pandey <dpandey@secf.com>
To: pgsql-sql@postgresql.org
To: pgsql-bugs-owner@postgresql.org
Subject: Migrated Oracle database to PostgreSQL ??
Date: Mon, 4 Apr 2005 19:11:17 +0530
Message-ID: <20050404134338.168FF53400@svr1.postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dpandey@secf.com, pgsql-bugs-owner@postgresql.org
Subject: Re: Migrated Oracle database to PostgreSQL ??
In-Reply-To: <20050404134338.168FF53400@svr1.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox