Thanks for the offer of help. Developer finally did a
DBMS__OUTPUT.DISABLE
followed by the DBMS_OUTPUT.ENABLE. This cleared the buffer and code
worked. Apparently he had a dirty buffer that didn't clear until the
DISABLE was issued. He has added the DISABLE to his code prior to the
ENABLE so that his output is going into an empty buffer.
Rodd
-----Original Message-----
From: Koivu, Lisa
To: Multiple recipients of list ORACLE-L
Sent: 8/27/01 1:35 PM
Subject: RE: ORA-10027 in ps/sql block
Rodd, can you post the code?
-----Original Message-----
From: Holman, Rodney [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:56 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-10027 in ps/sql block
I have a developer here who is trying to populate a cursor.
Every time he
runs his code he gets the above error stating that the buffer is too
small.
We have tried explicitly setting the buffer to 1,000,000 bytes. This is
FAR
greater than needed for the amount of data requested. No matter what
buffer
size we set he still gets the overflow.
We have tried both of the following ideas from metalink
Any ideas?
Rodd Holman
Doc ID: Note:1005230.6 Content
Type:
TEXT/PLAIN
26-AUG-1994
Type: PROBLEM Last Revision
Date:
13-JAN-1995
Status: PUBLISHED
Problem Description:
====================
Problem Explanation:
====================
NEW PROBLEM
Solution: INCREASE THE SIZE OF THE BUFFER
Solution Description:
=====================
Increase the size of the buffer. The size of the buffer must be an
integer
between
2,000 and 1,000,000.
Solution Explanation:
=====================
Use one of the following two methods to increase the size of the buffer:
1. At the SQL*PLUS or SQL*DBA prompt, type
SET SERVEROUTPUT ON SIZE n
where n is an integer between 2,000 and 1,000,000.
Example: To increase the buffer size to 10,000 type
SET SERVEROUTPUT ON SIZE 10000
2. Inside the PL/SQL block type
DBMS_OUTPUT.ENABLE(n)
where n is an integer between 2,000 and 1,000,000.
See Appendix A of the Oracle7 Server Application Developer's Guide
for
an explanation of the ENABLE command.
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
--
Author: Holman, Rodney
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Holman, Rodney
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
