Forum Stats

  • 3,875,462 Users
  • 2,266,926 Discussions


oralce 11g: getting error while loading javax.mail-1.6.2.jar ORA-29534: referenced object could not

Ora_Learner890 Member Posts: 368

hi all,

I am first time in this section (forum), actually I created topic here:

a senior instruct me to either ask this question on GitHub or    so I am here, no idea that this is appropriate place (as on given link by @BluShadow shows here various areas related to Java) i saw a similar topic (may be its not) and posting here, if its wrong section, please move it and inform accordingly.

Hope now I can get answer.

client want us to give solution to email from Oracle DB which run through Oracle Job and send emails to their clients, it means out of their own domain and also clients are using Public servers like Gmail, Outlook, Yahoo etc. etc. Also email should take files one-by-one from Oracle directory and attach with emails. ( PDF or Excel )

database verion:

SQL> select banner from v$version;



Oracle Database 11g Enterprise Edition Release - 64bit Production

PL/SQL Release - Production

CORE      Production

TNS for 64-bit Windows: Version - Production

NLSRTL Version - Production

downloaded javax.mail.1.6.2.jar from GitHub and trying to load with below command:  ( loading with SYS user credentials )

loadjava -u sys/[email protected] -o -r -v -f -noverify -synonym -g public javax.mail-1.6.2.jar

Errors:  ( various times )

ORA-29534: referenced object [ object names ] could not be resolved

mentioned above [ object names ] because these are various errors with those class names.

please help/guide, what are the requirements to load java in DB, is there any permissions required? is there any dependency's requried? is there any code to run before loading this jar file? etc. etc.