Re: [sqr-users] SQL Error = ORA-01406: fetched column value wastruncated

["Genady Sosnovsky" <genadys@ontko.com>]

Sheetal,

This can also happen for a following below case

select-begin
'1'   &some_str_var=char
.....
last_column

UNION begin
first.column_str_value
...
last_column

end-select

Oracle generates the ORA-01406 error when the first column from the first
sql of the union is "shorter" then the column from the second sql of the
union . It does not happen for all Oracle environments though.

Genady
genadys@ontko.com


----- Original Message ----- 
From: "Ray Ontko" <rayo@ontko.com>
To: <sqr-users@sqrug.org>
Sent: Friday, October 17, 2003 7:48 AM
Subject: Re: [sqr-users] SQL Error = ORA-01406: fetched column value
wastruncated


> Sheetal,
>
> The only adjustable parameter for SQR that I can think
> of that might be related to this error message
> is LONGSPACE=32766 in your -M or SQR.INI file.
>
> What's going on in that particular SQL statement?
> Are any of the columns "LONG" or "LONGRAW"?
>
> Ray
>
> On Fri, Oct 17, 2003 at 09:08:49AM +0530, sheetalk wrote:
> > Hi All,
> >
> > My working environment :  ps 8 sp2,  pt 8.15, oracle db
> >
> > I'm getting this error msg when i run one sqr only on production thr
> > process scheduler both on nt and unix..
> > On all other instances it works fine..
> > Surprisingly enough it runs fine on production from dos prompt with sqrw
> > command !!!
> >
> > I tried to trace if any particular data value causes this but i don't
> > get this error for particular data row..but it occurs mostly when
> > report data is large...
> >
> > SQL Status =    -1, SQL Error  = ORA-01406: fetched column value was
> > truncated
> > Error on line 59:
> >    (SQR 3301) Program stopped by user request.
> >
> > Which  options for sqr or oracle or process scheduler on production
> > should i check?
> > I've already compared pssqr.unx files on all instances and they are
> > same...
> >
> > Please help !!!!!
> >
> > Thanks & Regards,
> > Sheetal.
> >
> > *********************************************************
> > Disclaimer
> >
> > This message (including any attachments) contains
> > confidential information intended for a specific
> > individual and purpose, and is protected by law.
> > If you are not the intended recipient, you should
> > delete this message and are hereby notified that
> > any disclosure, copying, or distribution of this
> > message, or the taking of any action based on it,
> > is strictly prohibited.
> >
> > *********************************************************
> > Visit us at http://www.mahindrabt.com
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> ----------------------------------------------------------------------
> Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
> Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users