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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.
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 theUTL_FILE
package. For example, have a look at: http://feuerthoughts.blogspot.co.uk/2006/03/some-gotchas-with-oracle-xe.html