Non-working DBMS_LOB

From: Jusa Juutilainen <pjuuti_at_cs.joensuu.fi>
Date: 14 Apr 1999 13:10:22 +0300
Message-ID: <7f1pie$ns0@cs.joensuu.fi>

I have Oracle 8.0.4 Enterprise Edition on NT and I cannot use DBMS_SQL functions. For example

---

SQL> create table just_testing ( txt clob );

Table created.

SQL> insert into just_testing values ('sample row');

1 row created.

SQL> select dbms_lob.getlength(txt) from just_testing; select dbms_lob.getlength(txt) from just_testing

       *
ERROR at line 1:

ORA-04045: errors during recompilation/revalidation of SYS.DBMS_LOB
ORA-04091: table SYS.SEG$ is mutating, trigger/function may not see it
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1

---

I have run DBMSLOB.sql which provides interface and aAbove lines work on Oracle 8.0.3 EE (on NT).

Any ideas?

--

• jPj E-Mail: pjuuti@cs.joensuu.fi WWW: http://cs.joensuu.fi/~pjuuti/ "Deep inside ignorance prevails."

Received on Wed Apr 14 1999 - 05:10:22 CDT