Re: Oracle Supplied Packages !!!!!! where r the package bodies ?????????

Hello,

To create the UTL_FILE package, submit the Utlfile.sql and Prvtfile.plb scripts when connected as the user SYS. These scripts are run automatically by the CATPROC.SQL script.

Hth,

Erika

Venkat Iyer wrote:
>
> hi friends....
>
> i needed to use the UTL_FILE package to satisfy some application specific
> requirements..since i did not have the package already installed, i had to
> run the UTLFILE.SQL script....found in /ora81/rdbms/admin directory...
>
> this script *only* creates the package specification...it does *not* have
> the code to create the package body....after i executed the script, i assume
> it created both the package and the package body...and MY procedure which
> uses subprograms of UTL_FILE package, compiled fine...however when i
> executed it, it gave the following message :
> "NOT EXECUTED, PACKAGE BODY "USERNAME.UTL_FILE" DOES NOT EXIST"
>
> so i went and checked in USER_OBJECTS and i only found the package and not
> the body.
>
> also i found that this is the case with all the scripts which create the
> oracle supplied packages....they only contain the code to create the
> package.....and not the bodies....
>
> am i missing something here or being plain stupid or am i supposed to
> execute these files as SYS user ??? ( I don't think so) Or is something
> wrong with my installation ?????
>
> i am running Oracle 8i Enterprise Edition Release 8.1.5.0.0
>
> thanx in advance...
> venkat
Received on Tue Mar 27 2001 - 03:18:26 CST