Ora2Pg Migration – Hint: To call a procedure, use CALL.

While converting application from Oracle to PostgreSQL database and if the application uses procedure, following might be one of the exception you should have seen, Caused by: org.postgresql.util.PSQLException: ERROR: getCalculatedValues() is a procedure   Hint: To call a procedure, use CALL. The following line of code might exists in your code base, While calling procedures…

Insufficient privileges while connecting to Oracle Database from AWS Schema Conversion Tool

If you face Insufficient privileges issue while connecting to oracle database from Amazon AWS Schema Conversion Tool (SCT) like below, The specified account (abc_owner) does not have sufficient privileges for working with the following object(s): ORACLE Server : [SELECT ANY DICTIONARY] Run following command as system user in oracle server, grant select any dictionary to…

WP2Social Auto Publish Powered By : XYZScripts.com