| ora 06502 [message #54453] |
Tue, 19 November 2002 03:40  |
eelco oudbier
Messages: 3
Registered: October 2002
|
Junior Member |
|
|
We have a problem with our database. sometimes we keep getting ora 06502 even whene we try a desc table.
Is there a setting that has to be changed?
|
|
|
|
|
|
| Re: ora 06502 [message #54479 is a reply to message #54453] |
Tue, 19 November 2002 12:19  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Check for any invalid packages, procedures, views in SYS or SYSTEM schemas. ORA-06502 is usually happens when arthmetic, numeric, string, conversion, or constraint error occurred. Say you are trying to assign the value NULL to a variable declared NOT NULL, or if to assign an integer larger than the declared pressision.
If you still cannot find anything setup this event in your init.ora file and look at the trace file after the error happened again.
event="6502 trace name errorstack, level 4"
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
