calling PL/SQL from java

From: Martin Burkert (burki5000_at_gmx.at)
Date: 04/28/04


Date: Wed, 28 Apr 2004 11:23:50 +0200

I'm using Oracle 9.02, Java SDK 1.4 and the OCI-Version of jdbc. The
connection still works, and I'm able to send a simple "select
count(*)" -Statment to my database.
At the next step, I would like to call a PL/SQL-Statement from a
Java-Program.
The type of PL/SQL is: function myFunction (Var_in in varchar2) RETURN
varchar2

How is it possible to call this function from my java-application?
My java-function should have one argument (var_in), and should return
the returnvalue from the pl/sql-function.
It would be nice when anybody could post an example code in Java
because I'm new to it. ;-)

greetings
Martin