[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1327
  • Last Modified:

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/TCPConnection not exist


Oracle 8.1.7.1 WinNT 4.0

Who can help me?
0
belem
Asked:
belem
1 Solution
 
banickiCommented:
Hello, I found this out on metalink:

  Modify the INITPLSJ.SQL script to include the "-force" option when calling dbms_java.loadjava.


  INITPLSJ.SQL
  ------------
  set serveroutput on;
  call dbms_java.set_output(10000);
  call dbms_java.loadjava('-force -resolve plsql/jlib/plsql.jar');
0
 
banickiCommented:
Hello again,

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

0
 
jparelladaCommented:
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.
0
 
belemAuthor Commented:
the right answer cam from banicki
0
 
nadirpervezCommented:
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_DBConnectionCache"

ORA-04043: object /d2c5f8fe_DBConnectionCache does not exist

What should i do to drop these objects.

Regards
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now