Home » RDBMS Server » Server Administration » Problem when accessing a clob column..
Problem when accessing a clob column.. [message #54907] Sat, 14 December 2002 05:42 Go to next message
SSV
Messages: 11
Registered: October 2002
Junior Member
hello all,
i have a clob column in a table, and i am writing a procedure like print_clob(x clob) which will display the lob text...when i am running the procedure, i am getting the below error after displaying some text
ORA-20000 ORU-10027 BUFFER OVERFLOW, LIMIT OF 2000 BYTES
sys.dbms_output; line 91
sys.dbms_output; line 58..

how to set the buffer ?
plz help

VJ

Report message to a moderator

Re: Problem when accessing a clob column.. [message #54915 is a reply to message #54907] Sun, 15 December 2002 07:43 Go to previous message
Robert Kuhlmann
Messages: 35
Registered: March 2002
Member
set serveroutput on size 1000000

Report message to a moderator

Previous Topic: Urgent Oracle 8i
Next Topic: How to size SGA
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 11 12:16:33 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.