Re: UTL_FILE Woes

From: Mike Criscolo <mike_at_accretive.com>
Date: Mon, 12 Apr 1999 16:16:17 -0400
Message-ID: <7etkag$kij$1@camel0.mindspring.com>

Tom,

Sorry about the delay; I was out of the office all last week.

When I run the script you sent me, I get this message:

VALUE

Input truncated to 1 characters
declare
*

ERROR at line 1:

ORA-06509: PL/SQL: ICD vector missing for this package
ORA-06512: at "SYSTEM.UTL_FILE", line 119
ORA-06512: at line 18

I ran the script as system/manager. BTW, when I start SQLPlus as system/manager, I get this message:

Error accessing package DBMS_APPLICATION_INFO ERROR:

ORA-06509: PL/SQL: ICD vector missing for this package
ORA-06512: at "SYSTEM.DBMS_APPLICATION_INFO", line 22
ORA-06512: at line 1

Now, I have another tablespace set up called LIBRARIAN, and I have a "librarian" user id set up to access it by default. When I start SQLPlus for that user, I do not get the DBMS_APPLICATION_INFO error message. I do, however, get this message when I run the script you sent me as "librarian":

VALUE

Input truncated to 1 characters
declare
*

ERROR at line 1:

ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "LIBRARIAN.UTL_FILE" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 18

The end need is for me to be able to run UTL_FILE stuff logged in as the "librarian" user. I ran @CATPROC logged in as "system". When I tried to run it (erroneously) as "librarian", I got lots of error messages, mainly concerning lack of privledges to perform operations.

What did I set up wrong? How do I fix it? Thanks for your help.

-Mike Received on Mon Apr 12 1999 - 15:16:17 CDT