michael nesterenko
Reputation: 14439
pl sql exception message
I have following error message.
2011-08-08 14:27:09 [E]: xxx - ORA-06502: PL/SQL: numeric or value error:
character string buffer too small
ORA-06512: at "xxx", line 1671
ORA-06512: at "xxx", line 2083
ORA-06512: at "xxx", line 921
ORA-06512: at line 1
Can you tell me why there are many lines? It is stack unwinding or that messages were artificially put together?
Upvotes: 0
Views: 647
Answers (1)
Codo
Reputation: 78835
It's indeed stack unwinding.
You have probably called stored procedure from a database IDE such as Toad (line 1). That procedure has a procedure call at line 921, which in turn... The error eventually occurred in a procedure or function on line 1671.
If I'm not mistaken, exception handlers can also contribute lines to the multi-line error message.
Upvotes: 2