Re: Oracle package

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Wed, 03 Nov 1999 10:18:57 -0800
Message-ID: <38207C91.BA000690@vnl.nl>

mklondon1311_at_my-deja.com wrote:

> Hi..
>
> I'm trying to run a package and i keep getting the following errors.
>
> ORA-010000: Max Open Cursors Exceeded
>

Increase open_cursors in your init.ora. Or -probably better- review your procedure; it may keep opening cursors.

> ORA-20000: Buffer Overflow, limit of 999999bytes

Suppose you use dbms_output.put_line?
You used: set serveroutput 1000000? (not sure about the max) Otherwise you need to switch to using a pipe, check out the dbms_pipe package.

>
>
> If anyone knows why I'm getting these errors or how I could fix
> them.
>
> Please let me know
>
> Thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Wed Nov 03 1999 - 12:18:57 CST