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

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 - 01:17:00 CST