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);
All your answers can be found here: http://www.postgresql.org/docs/8.0/static/plpgsql.html
I can't say if PL/pgSQL is as good as PL/SQL, though.
Yasir
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
