calling PL/SQL from java
From: Martin Burkert (burki5000_at_gmx.at)
Date: 04/28/04
- Next message: Bjorn Abelli: "Re: calling PL/SQL from java"
- Previous message: Christophe Vanfleteren: "Re: Please help me"
- Next in thread: Bjorn Abelli: "Re: calling PL/SQL from java"
- Reply: Bjorn Abelli: "Re: calling PL/SQL from java"
- Reply: shay: "Re: calling PL/SQL from java"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Next message: Bjorn Abelli: "Re: calling PL/SQL from java"
- Previous message: Christophe Vanfleteren: "Re: Please help me"
- Next in thread: Bjorn Abelli: "Re: calling PL/SQL from java"
- Reply: Bjorn Abelli: "Re: calling PL/SQL from java"
- Reply: shay: "Re: calling PL/SQL from java"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]