Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CONVERT LIST TYPE FROM INFORMIX TO ORACLE

user558375Feb 15 2007 — edited Feb 16 2007

We are migrating a couple of Stored Procedures from Informix to Oracle.

What is the best option to migrate this function?:

CREATE FUNCTION proc(itemlist LIST (ROW (item_id INTEGER, item_format INTEGER, item_order INTEGER,
item_lenght DECIMAL(10,3), item date DATE) not null ),
listnumber INTEGER, listcode INTEGER, listformat INTEGER)

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 16 2007

Added on Feb 15 2007

#database-and-application-migrations

1 comment

2,948 views