cancel
Showing results for 
Search instead for 
Did you mean: 

Record Type issue

Highlighted
Adventurer

Record Type issue

Hi,

In Oracle, in the package plsql, there is a record type that is declare with three fields assume an initial value of zero.

Example:

DECLARE

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 :=

 

DECLARE

TYPE TimeTyp is RECORD (

seconds smallInt:= 0,

minutes smallInt:= 0,

hours smallInt:= 0);

 

Looking for some help to fix this issue.

Thanks

1 REPLY 1
EDB Team Member

Re: Record Type issue

Hi Angie,

 

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?