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