Exception ORU-10027 will be raised by DBMS_OUTPUT when

Options
- Line length overflow
- Buffer overflow
- Trying to connect to Oracle RDBMS, no network connection made
- Invalid directory path

CORRECT ANSWER : Buffer overflow

Discussion Board
Buffer overflow

The DBMS_OUTPUT package enables you to send messages from stored procedures, packages, and triggers. The package is especially useful for displaying PL/SQL debugging information. DBMS_OUTPUT subprograms raise the application error ORA-20000, and the output procedures can return the following errors:
ORU-10027: Buffer overflow
ORU-10028: Line length overflow
A buffer overflow occurs when a program or process attempts to write more data to a fixed length block of memory.

Prajakta Pandit 02-23-2017 12:51 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲