Oracle Database Discussions

Hi Friends,

I have a problem with the query which is called from CGI file.

I'm getting "rows will be truncated" error.

I have these settings followed by actual query which returns 64 columns

set arraysize 2000
set feedback off
set heading off
set line 10000
set newpage 0
set pagesize 0
set scan off
set space 0
set tab off
set trimout on
set verify off
set wrap off
set colsep |
whenever sqlerror exit 1
whenever oserror exit 2


this was working fine since more than an year but now it is giving issue. I guesssome OS or DB environment settings have been changed.
we didn't change any code but how this issue occurs?

please advice.

Thanks & Regards,
Kiran