-
unable to create package utl_mail in 10g
Environment: 10g (Windows server)
I am unable to create package utl_mail, Please help.
See below:
1. In oracle 10.2.0.2.0 WE8MSWIN1252 AMERICAN_AMERICA database
SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\utlmail.sql
Package created
Synonym created
SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\prvtmail.plb
Warning: Package body created with compilation errors
Errors for PACKAGE BODY SYSTEM.UTL_MAIL:
LINE/COL ERROR
-------- -----------------------------------------------
320/10 PL/SQL: ORA-00942: table or view does not exist
319/5 PL/SQL: SQL Statement ignored
326/12 PL/SQL: ORA-00942: table or view does not exist
325/7 PL/SQL: SQL Statement ignored
==================================================
2. In oracle 10.2.0.1.0 AL32UTF8 AMERICAN_AMERICA database
SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\utlmail.sql
Package created
Synonym created
SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\prvtmail.plb
Warning: Package body created with compilation errors
Errors for PACKAGE BODY SYSTEM.UTL_MAIL:
LINE/COL ERROR
-------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
85/2 PLS-00103: Encountered the symbol "TITRXOTC8"
85/27 PLS-00103: Encountered the symbol "=" when expecting one of the following:
-D
-
you need to create them as sys not system
-
Originally Posted by davey23uk
you need to create them as sys not system
Doing it with sys worked fine on
1. In oracle 10.2.0.2.0 WE8MSWIN1252 AMERICAN_AMERICA database. It created the pkg and body.
But I still get the original error on
2. In oracle 10.2.0.1.0 AL32UTF8 AMERICAN_AMERICA database
SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\utlmail.sql
Package created
Synonym created
SQL> @D:\oracle\product\10g\db_1\RDBMS\ADMIN\prvtmail.plb
Warning: Package body created with compilation errors
Errors for PACKAGE BODY SYS.UTL_MAIL:
LINE/COL ERROR
-------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
85/2 PLS-00103: Encountered the symbol "TITRXOTC8"
85/27 PLS-00103: Encountered the symbol "=" when expecting one of the following:
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|