[sqr-users] ORA-01458 error

[john.tucker@oracle.com]

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