How to call/invoke a Oracle package using java

Hi All

Can any one guide me how to call/invoke a oracle package using java.
i just tried like below code which is not working properly.

Code:

---

cstmt = con.prepareCall("{call P_Cat_Globals()}");

---

Can any one let me know how to call the package and then i have to read a variable from that package.

Thanks in Advacne.

"is not working properly" tells us nothing.

Hi

I tried to call the package same as of calling a proc so it doesn't work for me, can u guide how to call a package. that's y i specified it is not working properly.

Hi

Here is an example that shows you how to call a stored procedure and print the result. The code is simple but is completely.

Code:

---

DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:XE", "hr", "password");

String jobquery = "begin get_emp_info(?, ?, ?); end;";
CallableStatement callStmt = conn.prepareCall(jobquery);
callStmt.setString(1, "param1");
callStmt.setString(2, "param2");
callStmt.setString(3, "param3");
callStmt.execute();
       
ResultSet rset = (ResultSet)callStmt.getObject(3);

ResultSetMetaData rsetMeta = rset.getMetaData();
int count = rsetMeta.getColumnCount();
// print the results, all the columns in each row
while (rset.next()) {
    String rsetRow = "";
    for (int i=1; i<=count; i++){
        rsetRow = rsetRow + " " + rset.getString(i);
    }
    System.out.println(rsetRow);
}
conn.close();

---

I hope it will help you.

Quote:

---

Originally Posted by sasi.tati

Hi

I tried to call the package same as of calling a proc so it doesn't work for me, can u guide how to call a package. that's y i specified it is not working properly.

---

Errors?
Exceptions?
Crashes?

What's the signature of the procedure?

"{call <my procedure name>}" is sufficient if there are no parameters.
"{?=call <my function>}" is sufficient for a function with only a return parameter.