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
--
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).
