Query output incomplete

[Skydiver]

Hi,

I'm trying to capture and display Oracle Applications API error, it just displays 2 characters of the error, although to data size is 32 (retirieved by length(field_name))..I tried to insert the output in a temp table and query it, it would still show 2 characters only. Going to SQL*Plus, it displayed the full error text.

Could you please help me with that?

Regards

 

[Marco Kalter]

Perhaps the value contains the zero character? Can you try the following?

select replace(error, chr(0), ' ') from ...