Re: calling a external Java method from PL/SQL

uses a cryptography class that is proprietary to Sun. I sent the src to Oracle and they told me it wouldn't work.

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:9n85c9$89i$1_at_babylon.agtel.net...
> Hmm,
>
> can you please explain the reason why this class cannot be loaded
> into the database? methods that take strings and return string are
> perfectly loadable into 8i and callable from pl/sql (with wrapper
> using varchar2 for string parameters and result). Also, if it is
> mandatory that class is not loaded into the db, can you implement
> the algorithm in C or C++?
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
> "amobiuz" <amobiuz_at_myrealbox.com> wrote in message
news:2eacf143.0109051932.6b3d458f_at_posting.google.com...
> > Situation:
> >
> > I have a Java class file with a method that take a string and returns
> > a string. This can _not_ be compiled into the database. I need to
> > call its method from a PL/SQL stored procedure.
> >
> > As far as I'm aware external methods must reside in a shared library
> > (C .so file).
> >
> > Question:
> >
> > Can a .class file be "compiled" into a shared library that Oracle can
> > call externally. If so how?
> > If not, can a C .so file be created to call the java method with then
> > passes the value back to the external C method, in return to the
> > PL/SQL procedure.
> >
> > TIA
>
Received on Fri Sep 21 2001 - 06:10:42 CEST