Mapping P4 to SQL Oracle 8

[sautier]

Hello everybody !

I have a single question about the mapping between P4 (Sc 4.1.1) and Oracle 8.

I have the fields comments of my request wich is a array of caracter.
In the mapping of my OCMQ file betwenn P4 to Oracle I have a SQL type varchar2(2000) but it's too short and my filed is truncated !
I have test a sql type like varchar2(4000) it's better.

Who have another solution ? Use lob or blob ? and How

Thanks !!

[harn145]

You can use several solutions, including BLOB or "secondary tables".

All these options are described in the Data Administration guide. This includes fieldtype descriptions and mapping strategy (including setup issues).