-
Error in running InitJVM.SQL
I have run 2 procedures(INITJVM.SQL AND INITPLSJ.SAL) to send e-mail .
They have been successfully deployed. I am able to send Mails from stored procedures successfully. But, by mistake somehow its not sending e-mails at all. Again i ran the 2procedures but, when i am running the first procedure, its not running succesfully now, its saying so many errors like the below
drop role javauserpriv
*
ORA-00604: error occurred at recursive SQL level 1
ORA-29540: class oracle/aurora/mts/http/security/RdbmsHttpPolicy does not exist
ORA-06512: at "SYS.HTTP_SECURITY_CASCADE", line 0
ORA-06512: at line 3
create role javauserpriv
*
ORA-01921: role name 'JAVAUSERPRIV' conflicts with another user or role name
Statement processed.
drop role javaidpriv
*
ORA-00604: error occurred at recursive SQL level 1
When i am dropping the above roles its not allowing me from SQLPLUS too.
please anyone can tell me the solution as my work got struck due to this severe problem
Regards
Vinod
-
you cannot re-execute 'initjvm', you have to remove it first using 'rmjvm'. Then after that you can again execute 'initjvm'
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
|