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?
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.