Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to load External Resources such as Jar’s? Help in resolving ORA-29534

449907Aug 8 2009 — edited Aug 8 2009
Agenda: FTP files on Oracle 11g version 11.1.0.6.0 database server on Windows 2003 to another server. These files are generate using PL/SQL and Java Stored procedure

Implementation Details: I wrote java stored procedure for FTPing files. Protocol is FTPS and I’m using Apache common’s library commons-net-ftp-2.0.jar.

Now trying to load my project jar file using loadjava and it results into ORA-29534 error. I added location of commons-net-ftp-2.0.jar in the system class path and rebooted database server.

Question:+ How do I tell oracle location of external_ JAR files? I also tried dropping external jar to jlib and jdk lib. No Luck!

I will really appreciate your help…. Need to resolve it urgently for delivery

See the details
C:\TEMP>call loadjava -r -f -o -user <SCHEMA_NAME>/<PASSWORD>@ORCL projectFTPS.jar

errors : class ftp/DibrsFTP
ORA-29534: referenced object SFMIS5_2.ftp/DibrsFTPClient coul
d not be resolved
errors : class ftp/DibrsFTPClient
ORA-29521: referenced name org/apache/commons/net/ftp/FTPSClient could not b
e found
ORA-29521: referenced name org/apache/commons/net/ftp/FTPClient could not be
found
The following operations failed
class ftp/DibrsFTP: resolution
class ftp/DibrsFTPClient: resolution
exiting : Failures occurred during processing


Thanks,
Madan

Edited by: MadanShah on Aug 8, 2009 8:00 AM

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 5 2009
Added on Aug 8 2009
#11g, #plsql
4 comments
1,017 views