Forum Stats

  • 3,875,462 Users
  • 2,266,926 Discussions
  • 7,912,223 Comments

Discussions

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

Ora_Learner890
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;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for 64-bit Windows: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - 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.

regards

Answers