Calling Oracle stored procedures from Java app.

From: Charles A. Christiansen, Jr. <charles_at_iconstructs.com>
Date: 1998/01/21
Message-ID: <885416873.59703298@dejanews.com>#1/1

Hi all,

I'm relatively new to both Java and Oracle, so I'm wondering if someone can help me here.

I have a Java app (JDK 1.1.4) which talks to an Oracle 7.3.3 database via the Oracle Thin JDBC driver. Currently, I'm passing the SQL through with the Statement.executeQuery(String s) and Statement.executeUpdate(String s) methods, but I'm guessing that I can get better performance all around if I use stored procedures instead. My question is, how do I call an Oracle stored procedure from my Java code? Is there a Java method that will handle this for me, or will it require some heavy duty coding to get working?

This is Oracle 7.3.3 WG Server running on Windows NT Server 4.0, Service Pack 3 and JDK 1.1.4 also running on NT Server 4.0, SP3 (but on a different server), and the most recent Oracle Thin JDBC driver (version number is escaping me right now).

Thanks in advance for the help,

---

Charles A. Christiansen, Jr.
Programmer / Analyst
Interactive Constructs, Inc.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Wed Jan 21 1998 - 00:00:00 CST