Re: How can I access java procedures from PL/SQL (sqlplus) in 9i

Sure it is possible.

Say you have loaded a Java Class into your database :

public class foo {
  public static void dosomething (float a, float b)    {
     / * Your code here */
    }
}

Then you wrap it's method(s) in a "call spec" to access it from PL/SQL :

CREATE OR REPLACE PROCEDURE foo_dosomething(a number,b number) AS LANGUAGE JAVA
NAME 'foo.do_something(float, float)';

You can now call it's methods from PL/SQL:    

BEGIN
  foo_dosomething(1,2);
 END;
/

And that's about it.

It's fully covered in the on-line doc under "Oracle9i Java Stored Procedures Developer's Guide".

• Kenneth Koenraadt

On 7 Oct 2002 00:00:22 -0700, tloim_at_yahoo.com (E. Taner Tumer) wrote:

>Hi,
>
>I want to use some of the builtin java classes in my PL/SQL functions.
>Can it be possible? If so would you please send me some sample code
>written in PL/SQL.
>
>Thanks,
Received on Mon Oct 07 2002 - 02:43:01 CDT