Tag: Migration

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…

The code like this in your program can throw “Data Type Mismatch Error” at run time. Following is the actual runtime error will come in the application, Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: smallint <> character varying  Hint: No operator matches the given name and argument types. You might need to add explicit…