Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Question regarding Buffer Overflow

Janno Enrico EnriquezJan 5 2018 — edited Jan 5 2018

Hi!

I just want to ask regarding buffer overflow.

Currently we are encountering buffer overflow on one of our package. (after approval)

We are trying to replicate the error "ORA-20000: ORU-10027: buffer overflow, limit of 100000 bytes".

But upon checking of the package. It only uses few dbms_output and no loop inside.

We are wondering how does this program outputs 100000 bytes of char without using a loop.

Are there any other possible cause for this error?

Thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2018
Added on Jan 5 2018
12 comments
680 views