These notes are for errors that I have not been in a position to investigate
and write up thoroughly.
- Error typically arises when importing into an earlier version of
Oracle than that with which the export was made. A work around may be
to use the export tools that came with the (earlier) version of oracle
that you intended to import into.
- ORA-06502: PL/SQL: numeric or value error
- Normally implies that a buffer is too small for the result set.
PL/SQL limits the maximum variable size to 32K.
This page represents one page of many pages of notes I made whilst working
with Oracle 7 through to 10i. I now no longer work with Oracle databases,
but hope that these notes will continue to be of benefit to others.
About the author: Brian Cryer
is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.