Re: calling a external Java method from PL/SQL

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Thu, 6 Sep 2001 19:43:40 +0400
Message-ID: <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 Thu Sep 06 2001 - 17:43:40 CEST