Oracle java Stored Procedure & JDBC
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Horatiu_Ripa
Posted On:   Wednesday, April 3, 2002 01:41 AM

Is there a way to insert via JDBC an Oracle Java Stored Procedure?

Re: Oracle java Stored Procedure & JDBC

Posted By:   Mohamed_Ibrahim  
Posted On:   Friday, April 5, 2002 12:26 AM


hi,
pls make ur question clear, is it mean how to execute a oracle procedure thru JDBC, if so, thru CALLABLE STATEMENT your requirement can be made.


eg.

CallableStatement checkCallStmt = tableCon.prepareCall("{call EmployeeQuery(?)}");

checkCallStmt.setString(1, "ibu");

checkCallStmt.registerOutParameter(1,1);

ResultSet rs = checkCallStmt.executeQuery();


while(rs.next()){

System.out.println("Callable Statement : " + rs.getString("age"));


is this ur requirement.
About | Sitemap | Contact