Hi,

Appreciate if anyone could help to solve this prob.

Scenario
======
The oracle table A has a field named "comments" with a datatype char(2000). An PL/SQL is suppose to insert records from oracle table A into a baan table B with a field named "t$comments#1" with a datatype char(255) and "t$comments#2" with a datatype of char(1).

Question
=======
What are the best possible options?


Thanks & Kind Regards,
Zaid

Are you looking for Oracle stuff or if Baan can handle it?

Kind regards,
Dick

I'm looking for alternative to oracle stuff. If baan can handle it, please let me know.

When using Oracle 8 or higher, Baan can handle more than 255 char in a column when not setting ora_column_format:7. When this has been set: don't change it back on the fly as probably your tables are created in Oracle 7 format.

Baan does not support ways to do insert in non Baan tables but this can be solved by views or triggers.

Kind regards,
Dick