PL/SQL - About dbms_output.put

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 229 of 237

About dbms_output.put_line( ) package

what is the maximum size of the message that we can give in dbms_output.putline();

Total Answers and Comments: 4

Last Update: December 16, 2008 Asked by: usrkraju

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 18, 2008 16:35:13

kiwisheep

Member Since: July 2008 Contribution: 1

RE: About dbms_output.put_line( ) package

the maximum output is determined by the size you specified in dbms_output.enable(<size>).

Is this answer useful? Yes | No

July 21, 2008 00:48:31

sippsin

Member Since: June 2006 Contribution: 6

RE: About dbms_output.put_line( ) package

Here is an Error when i tried to give too many characters in Dbms_Output.put_line

ORU-10028:

Search results:

The following seemingly harmless statement produces an ORU-10028: line length overflow, limit of 255 bytes per line error:

This is because dbms_output.put_line cannot print lines that exceed 255 characters.

Is this answer useful? Yes | No

August 05, 2008 01:52:48

jp_valapad

Member Since: August 2008 Contribution: 1

RE: About dbms_output.put_line( ) package

255 bytes was the size limits of earlier version of oracle..ie prior to 10 g ..in 10g 32767 byte is the limit..

Is this answer useful? Yes | No

December 15, 2008 23:12:49

kantri

Member Since: October 2008 Contribution: 4

RE: About dbms_output.put_line( ) package

The maximum size of package is 32k
We can't give Â more than that

Is this answer useful? Yes | No