Home » RDBMS Server » Enterprise Manager » A problem when executing PL/SQL in Oracle 8i Database release 3. URGENT !!!
A problem when executing PL/SQL in Oracle 8i Database release 3. URGENT !!! [message #144533] Wed, 26 October 2005 23:00
hendy_wjj
Messages: 11
Registered: August 2005
Location: Jakarta
Junior Member
Dear All...

My problem is :
I’ve some syntax than running in Oracle 9i Database release 2 (9.2.0.10), but when i try to do the same thing in Oracle 8i database release 3 , an error occured.
Here is my step in Oracle 9i Database :

SQL>Create user usernameA identified by usernameA;
SQL>grant create session, resource, grant any privilege, create user, create any procedure, pemirole to usernameA with admin option;
SQL>Connect usernameA/usernameA;
SQL>create user usernameB identified by usernameB;
SQL>grant create session, resource, create procedure, alter user to usernameB;
--i made a procedure named CREATE_MAILJAVA to execute create or replace statement below
1. CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED USERNAMEB.SENDMAIL AS........
2. CREATE OR REPLACE PACKAGE USERNAMEB.SENDMAILJPKG AS.......
3. CREATE OR REPLACE PACKAGE BODY USERNAMEB.SENDMAILJPKG AS......

SQL>Connect usernameB/usernameB;
--execute a command to send email using SendMailJKPG
Success send an email.

But when i'm doing same thing in Oracle 8i Database it a error when i'm execute CREATE_MAILJAVA:
ORA-24344: success with compilation error
ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "USERNAMEA.CREATE_MAILJAVA", line 8
ORA-06512: at line 1

i'm connect to sys/sysdba
SQL>grant execute on dbms_sys_sql to usernameA;
SQL>grant execute on dbms_sql to usernameA;
SQL>grant dba to usernameA with admin option;

than :

SQL>connect usernameA/usernameA
SQL>Execute CREATE_MAILJAVA
It's a error :

ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 824
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "HENDY.CREATE_MAILJAVA", line 8
ORA-06512: at line 1

What should i do ? what is missing in my statement ? all syntax running in Oracle 9i Database. Is there any grant differences between Oracle 8i DB and Oracle 9i DB ?
How can i add a privilege that exist in Oracle 9i DB to Oracle 8i DB ? for example : i want to add "grant any object privilege" in Oracle 9i DBA to Oracle 8i DBA

Thank you

Regards

Hendy
Previous Topic: unable to login to the database
Next Topic: Oracle 9i on Linux Red Hat 9 - Problems
Goto Forum:
  


Current Time: Mon May 16 06:13:22 CDT 2022