Don't confuse with the line number . If there is any data type mismatch
you would get this error.

In a number field, if the characters are coming you may get the error




"Vivek Gupta " <oracledba-ezmlmshield-x11527191.[Email address protected]
09/08/2005 05:31 PM


To

"LazyDBA Discussion" <[Email address protected]
cc





Subject
help ORA-06502 and ORA-06512






Hi All,
I am getting an error ORA-06502 : numeric error ORA-06512 : at line 28
while executing a pl/sql block.

The line 28 is like 'for cur_temp in c_temp'

Can anyone help me out to solve this error.

Thanks
Vivek Gupta


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Information transmitted by this EMAIL is proprietary to iGATE Group of
Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is
privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL
immediately notify the sender at iGATE or [Email address protected]
and delete this EMAIL including any attachments
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page