467,073 Members | 1,262 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,073 developers. It's quick & easy.

[HELP]Using Oracle9i db to call .Net Web Service from Java Stored Procedure

Hi all,

I am trying to make use Oracle9i db to call an external .Net Web
Service from a JAva Stored Procedure.

I created the .Net Web Service and use JDeveloper
to create the Client Stub Java class(ie: serviceClientStub.java).

Following the instruction from the article"Calling External Web
Service from Java Stored Procedure",
I connected to the database using SQL Navigator4.3 tried to load the
required jar files(with Create public synonym and Resolve option
checked) into Oracle9i database(ver They are loaded in the
following order:

Where [OC4J_HOME] refers to Oc4j_extended that I downloaded from
Oracle website.
[ORACLE_HOME] refers to oracle/ora90

However, most of the java classes failed to compiled. When I loaded
the Client Stub class, it failed to compile as well.

This is the error message that I got:
ORA-29521: referenced name javax/mail/Flags could not be found
ORA-29521: referenced name javax/mail/MessageException could not be
ORA-29521: referenced name javax/mail/MethodNotSupportedException
could not be found

Any ideas how to resolve these issues?

Also, besides using the Client Soap stack library(above method), is
there another way to be able to load the Client Stub class in the
database, have it compiled successfully?

Your assistance will be highly appreciated!
Jul 19 '05 #1
  • viewed: 1981

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Simon Matthews | last post: by
6 posts views Thread by segis bata | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.