Menu

How to create UTL_FILE package spec and body creation from rdbms\admin\sql script in SYSTEM schema in Oracle 11G express edition?

2015-06-09
2015-07-02
  • Indrajit Mohapatra

    Hi,
    I have installed "oracle 11G express edition" and all "utplsql 2.3.0".
    UTL_FILE package has not created in SYSTEM schema in "oracle 11G express edition".
    I am trying to create spec and body for UTL_FILE package.
    I executed utlrp.sql in SYSTEM schema in oracle 11G express edition.
    But I am getting following error:-
    SQL> @C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\utlrp.sql;
    SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual
    *
    ERROR at line 1:
    ORA-00904: "DBMS_REGISTRY_SYS"."TIME_STAMP": invalid identifier
    Need your help for above issue.

     
  • Paul Walker

    Paul Walker - 2015-07-02

    I don't know if this is your issue, but I've seen some webpages suggest that you need to log on as SYS and grant execute privilege on the UTL_FILE package. For example, have a look at: http://feuerthoughts.blogspot.co.uk/2006/03/some-gotchas-with-oracle-xe.html

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.