RE: [sqr-users] ORACLE OCIStmtFetch error 1406 <SQR 3725> Badreturnedfetching row from database.

["Ganesh, Muralidhar \(IE10\)" <Ganesh.Muralidhar@honeywell.com>]

Hi Clark,

What exactly should I check in the data? Table doesn't contain any
column with long data type. 

The same query works fine in the SQL* PLUS and toad but only in the SQR
it fails. SQR don't give error while fetching the subset of the rows in
the table with some where conditions but, while selecting the whole data
it gives an error. 

Will the values for the following does matter in the PSSQR.ini
[Processing-Limits] 
; DYNAMICARGS       
 DYNAMICARGS        
 EXPRESSIONSPACE    
 FORWARDREFS        
 NUMVARIABLES       
 ONBREAKS           
 POSITIONS          
 PROGLINEPARS       
 PROGLINES          
 QUERIES            
 QUERYARGS          
 SQLSIZE            
 STRINGSPACE        
 SUBVARS            
 VARIABLES          
 WHENS              
                    
; BREAKS            
; LONGSPACE         

Regards,
Ganesh A.M

----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com] Sent: Sunday, August 13,
2006 7:15 PM
To: sqr-users@sqrug.org
Cc: Ganesh, Muralidhar (IE10)
Subject: RE: [sqr-users] ORACLE OCIStmtFetch error 1406 <SQR 3725> Bad
returnedfetching row from database.

Check you *Data* first.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery. If you earn a salary, your employer is renting
your 
services for 40 hours a week, not purchasing your soul. Your time is the

only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only
you 
can determine how it will be spent. Be careful lest you let other people

spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

Hi all.

An SQR which execute select query and writes the data in to file which
was working fine is not completing to success after a database refresh
and PTools Upgrade to 8.22.

I am getting following error in the mid of the execution (not all the
rows are fetched).


<SQR 5528>ORACLE OCIStmtFetch error 1406 in cursor 25:

         ORA-01406: fetched column value was truncated.

Error on line 159

<SQR 3725> Bad returned fetching row from database.

I am not sure whether it is due to the refresh and Ptools upgrade.

Kindly help me in resolving this issue.

Regards,

Ganesh A.M

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's
FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


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