I am using an oracle driver to connect to Oracle8.1.7 database. I am able to connect to a table, but when I try to connect to stored procedure, it always throws error.
The code that I am using to connect to table is
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
con = DriverManager.getConnection("jdbc
racle:thin:@sfddb:1527
EV", "ID", "PWD");
This code works to connect to table :
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from PO.PO_HEADER ");
But this code fails :
CallableStatement cstmt = con.prepareCall("{? = call PO.WFC_GETPO(?)}");
cstmt.clearParameters();
cstmt.registerOutParameter(1, OracleTypes.VARCHAR);
cstmt.setInt(2, 222);
cstmt.execute();
System.out.println(cstmt.getString(1));
Well I have already tried different combination of values to call this stored procedure.
The stored procedure takes and In parameter as PO Number and returns true or false as boolean value. We are able to call this stored procedure from some other external sources.
Are we missing some setting before calling stored procedure?
Well you can consider me a novice in
Java Oracle connection with stored procedure. And I have already studied the stored procedure samples available on Oracle site.
Will appreciate any help
Vijay
SCJP, SCJD, SCWCD1.4, IBM486, IBM484, IBM 483, IBM 287, IBM141, IBM Certified Enterprise Developer - WebSphere Studio, V5.0
Author of IBM 287 Simulator Exam