belem
asked on
Error ORA 04043 class oracle/plsj/net/TCPConnection not exist
Hi,
i wish to send email from database and by installng the required JAVA classes with initjvm.sql as sys and by run initplsj.sql in the Database
i recive this error:
ERROR ORA 04043 class oracle/plsj/net/TCPConnect
Oracle 8.1.7.1 WinNT 4.0
Who can help me?
i wish to send email from database and by installng the required JAVA classes with initjvm.sql as sys and by run initplsj.sql in the Database
i recive this error:
ERROR ORA 04043 class oracle/plsj/net/TCPConnect
Oracle 8.1.7.1 WinNT 4.0
Who can help me?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This error ORA-04043, "object %s does not exist" is a true error.
Check your java option database. I think that your java option is not available.
For check yout java option:
1. Select count(*) from dba_objects where object_type like 'JAVA%' ;
If the answer is more or less 6000 objects, it's ok.
Otherwise execute
create or replace java system
/ (note:with slash!!)
And run the check.
Check your java option database. I think that your java option is not available.
For check yout java option:
1. Select count(*) from dba_objects where object_type like 'JAVA%' ;
If the answer is more or less 6000 objects, it's ok.
Otherwise execute
create or replace java system
/ (note:with slash!!)
And run the check.
ASKER
the right answer cam from banicki
Hellow,
I am also facing this problem with oracle applications. At my database layer when i query INVALID objects it shows me the JAVA CLASS objects, but when i try to drop those objects using the following command it gives an error as follows.
SQL>drop JAVA CLASS "/d2c5f8fe_DBConnectionCac
ORA-04043: object /d2c5f8fe_DBConnectionCach
What should i do to drop these objects.
Regards
I am also facing this problem with oracle applications. At my database layer when i query INVALID objects it shows me the JAVA CLASS objects, but when i try to drop those objects using the following command it gives an error as follows.
SQL>drop JAVA CLASS "/d2c5f8fe_DBConnectionCac
ORA-04043: object /d2c5f8fe_DBConnectionCach
What should i do to drop these objects.
Regards
There is a Note:122051.1 out on metalink about this error, but its not available for public viewing.
http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=122051.1
You could request it on metalink, if your experiencing the problem.
Well, I'm wrong again. I can get to it.
Search on 122051.1...
banic