[sqr-users] RE: ORA-01458 error

[john.tucker@oracle.com]

I discovered the source of the error, and thought I'd pass on what it was.

In this SQR, I had decided to try something out for the first time (always 
dangerous).  I had a couple of variables that I wanted to have decimal places, 
but I wanted the rest to be just integers, so in my declare-variables block, I 
declared the default number type as integer, and then specified the few 
variables that needed decimals, and how many places they needed.

Well, I don't know what I got wrong about it, but that was the problem.  I 
removed the declarations and added edit masks to the few times I needed to 
display a number or turn it into a string, and the error disappeared.  If 
anyone's an expert on the subject and would like to have a stab at figuring out 
what I did wrong with my declaration/subsequent use of declared variables, let 
me know - I'm still interested in what really happened.

-John T.


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