DaveBarber
Active Member
I need to read a clob field off the database into a JDE form. The clob has data in excess of 5000 characters.
I tried the following dd item changes for the value to be read into in the form via a table IO.
In all cases the data was truncated and could not be read in from the database:
- data item of legnth 16384, type string.
- data item of legnth 16384, type variable string.
- data item of legnth 16384, type clob.
The max size the form variable can retrieve in is 2000. Above this the table IO fails with the following message in the JDE.LOG:
2336/3592 Fri May 16 09:03:11 2008 dbfetch.c166
OCI0000056 - Unable to fetch - SELECT * FROM PRODDTA.F5555288 WHERE ( SC55WID1 = :KEY1 AND SCUSER = :KEY2 AND SCJOBN = :KEY3 AND SCUKID = :KEY4 )
2336/3592 Fri May 16 09:03:11 2008 dbfetch.c172
OCI0000057 - Error - ORA-01406: fetched column value was truncated
Any ideas of how to get around this problem?
Dave
JDE XE SP22 on Oracle 9.2.0.7
I tried the following dd item changes for the value to be read into in the form via a table IO.
In all cases the data was truncated and could not be read in from the database:
- data item of legnth 16384, type string.
- data item of legnth 16384, type variable string.
- data item of legnth 16384, type clob.
The max size the form variable can retrieve in is 2000. Above this the table IO fails with the following message in the JDE.LOG:
2336/3592 Fri May 16 09:03:11 2008 dbfetch.c166
OCI0000056 - Unable to fetch - SELECT * FROM PRODDTA.F5555288 WHERE ( SC55WID1 = :KEY1 AND SCUSER = :KEY2 AND SCJOBN = :KEY3 AND SCUKID = :KEY4 )
2336/3592 Fri May 16 09:03:11 2008 dbfetch.c172
OCI0000057 - Error - ORA-01406: fetched column value was truncated
Any ideas of how to get around this problem?
Dave
JDE XE SP22 on Oracle 9.2.0.7