RE: [sqr-users] ORA-01458 error

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

When you checked the length of the variables' values, did you account for
the possibility of trailing blanks?  You don't want to say:

Show $value

You need to say:

Show '*' $value '*'



-----Original Message-----
From: john.tucker@oracle.com [mailto:john.tucker@oracle.com] 
Sent: Monday, March 20, 2006 2:51 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] ORA-01458 error

I'm trying to run an SQR that I just finished writing, and I'm getting an
error I haven't seen before:

ORA-01458: invalid length inside variable character string

The SQL statement causing the problem is an Insert, and it successfully
inserts the first row, but bombs on the second.  I've carefully checked the
lengths of the data within the variables I'm using in the insert statement,
and none of the values are longer than the fields should be able to hold.  

There are four fields that have longer values in the second row than the
first, but I just can't see anything wrong with them.  Those four values are
still well within the limits of the field lengths.

Can any of you offer a suggestion on what it is that I'm missing?  Thanks
for any help you can offer.

-John Tucker


_______________________________________________
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