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

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

I had this problem a few weeks ago.  In my case, there were extended ASCII
characters (between 128 and 255) in a character field.

-----Original Message-----
From: Larry Roux [mailto:LRoux@syr.edu] 
Sent: Sunday, August 13, 2006 10:17 AM
To: Ganesh.Muralidhar@honeywell.com; the dragon; sqr-users@sqrug.org
Subject: RE: [sqr-users] ORACLE OCIStmtFetch error 1406 <SQR 3725>
Badreturnedfetching row from database.

Try this:

begin-select
{field list}
  show {keys}
from {tablename}
end-select

it should create a cursor and iterate through the table until it hits
the row that is broken.  The last display should eb the row before
that.

You will probably want to do an order-by to ensure you know what row is
giving you the issue.  Then look at the data in the row to see if there
is something odd there (control characters or something)






Larry Roux
Information Systems
Syracuse University
lroux@syr.edu


>>> Ganesh.Muralidhar@honeywell.com 8/13/2006 11:53:47 AM >>>

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

_______________________________________________
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