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/oracle@orcl -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