Home -> Usenet -> comp.databases.oracle -> Stored procedures & JDBC?

Stored procedures & JDBC?

From: Kresimir Musa <kresimir.musa_at_fer.hr>
Date: Thu, 26 Apr 2001 00:24:07 +0200
Message-ID: <9c7irt$fgbj$1_at_as121.tel.hr> 






I'd be thankful if someone could explain the proper way to call an Oracle
stored procedure from Java servlet.


I've created a procedure using Oracle DBA Studio
(Database->Schema->Procedure->Create...). When I try to execute it from SQL
Plus it works fine.


When I try to invoke this procedure from my servlet using


    CallableStatement stmt = conn.createStatement("{call proc_name(?,?)}");
    stmt.execute();


i get an SQLException saying that proc_name needs to be declared!



Am I missing something here...?
Received on Thu Apr 26 2001 - 00:24:07 CEST












Original text of this message