oracle to postgres migration table type issue

Question

As shown in the image I'm facing this issue

I'm getting syntax error.

Please read meta.stackoverflow.com/questions/285551/… and the accepted answer — user330315
– user330315, Commented Apr 25, 2017 at 12:33
Where in the Postgres manual did you find that TABLE OF is supported in Postgres? — user330315
– user330315, Commented Apr 25, 2017 at 12:34

Laurenz Albe · Accepted Answer · 2017-04-25 12:42:57Z

2

PostgreSQL and Oracle are two different relational database systems.

They have different SQL dialects, and the stored procedure languages PL/SQL and PL/pgSQL are somewhat similar, but different when you get to the details.

You probably want to translate

TYPE mytype IS TABLE OF mytab.mycol%TYPE;
myvar mytype;

to

myvar mycoltype[];

(assuming that mytab.mycol is of type mycoltype.)

The syntax will be different, but you can do similar things.

answered Apr 25, 2017 at 12:42

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

pozs Over a year ago

%TYPE is supported too by PL/pgSQL, but unfortunately, the syntax does not allow arrays to be created from such references.

Collectives™ on Stack Overflow

oracle to postgres migration table type issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related