Hi there,
Has anyone migrated Oracle database to PostgreSQL? If yes, could you please help me -
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
