Accessing a packaged procedure from JDBC

[amolso]

In my normal JDBC program I execute SQL query as below

ResultSet rset = stmt.executeQuery("select empno, rpad(ename,6), deptno from emp"

However if in same program I have to access a package in Oracle and a procedure therein what is the function in java for it.
I have tried ("exec pack.proc1&quot in executeQuery as execute function's format. But it's not working

Amol
amolsonaikar@yahoo.com
[sig][/sig]

 

[wduty]

You might be able to do this with CallableStatement. There's an explanation at:

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

regarding stored procedures. This might help although I've never worked with Oracle so I don't know what a &quot;package&quot; is as you're referring to it. [sig]<p>--Will Duty<br><a href=mailto:wduty@radicalfringe.com>wduty@radicalfringe.com</a><br><a href= > </a><br> [/sig]