In Oracle, in the package plsql, there is a record type that is declare with three fields assume an initial value of zero.
TYPE TimeTyp is RECORD (
seconds SMALLINT:= 0,
minutes SMALLINT:= 0,
hours SMALLINT:= 0);
After converting the record type from Oracle to EDB Postgres using the EDB Migration Toolkit and inserting into db, a syntax error near and at :=
seconds smallInt:= 0,
minutes smallInt:= 0,
hours smallInt:= 0);
Looking for some help to fix this issue.
Could you please share the complete DDL of the package with its dependent objects so that we can test it locally to provide you a workaround?