[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Oracle/SQR Error??

If you add -s to your sqr flags if will show you all the cursors and you
can see which field it is having a problem with.

-----Original Message-----
From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf
Of Miller, Danika
Sent: Thursday, August 05, 2004 3:26 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Oracle/SQR Error??


Hello -

 

I have an SQR report that is executed by entering specific input values
on a
run control page.  The report has many possible variations of input
variables.  The report runs fine with certain input variables and not
for
others.  This is the error that appears when the report isn't working
properly.

 

(SQR 5528) ORACLE OCIStmtFetch error 1406 in cursor 4:
   ORA-01406: fetched column value was truncated
 
Error on line 574:
   (SQR 3725) Bad return fetching row from database.
 
SQR for PeopleSoft: Program Aborting.

 

 

What exactly does this error mean?  What do my input variables have to
do
with this error?  And how can I avoid receiving this error again?  

 

 

Any help would be greatly appreciated!!!!

 

_______________________________________________
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