Re: How Does Oracle Do This?

From: Niall Litchfield <Niall.litchfield_at_dial.pipex.com>
Date: Wed, 21 Sep 2005 18:57:14 +0100
Message-ID: <43319e15$0$22943$cc9e4d1f@news.dial.pipex.com>

DA Morgan wrote:
> SQL*Plus: Release 10.1.0.4.0 - Production on Mon Sep 12 18:09:39 2005
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
> With the Partitioning, Oracle Label Security, OLAP and Data Mining options
>
> SQL> desc DBMS_SQLPLUS_SCRIPT
> ERROR:
> ORA-03117: two-task save area overflow
>
> SQL> SELECT owner, object_type
> 2 FROM dba_objects
> 3 WHERE object_name = 'DBMS_SQLPLUS_SCRIPT';
>
> OWNER OBJECT_TYPE
> ------------------------------ ----------------
> SYS PACKAGE
> SYS PACKAGE BODY
> PUBLIC SYNONYM
>
> How can they produce an ORA-03117 from a simple DESCRIBE?

DBMS_METADATA has done this for a while.

Yes it's probably fixed in some recent patchset. Still shouldn't happen.

Niall Received on Wed Sep 21 2005 - 12:57:14 CDT