Oracle Procedure out parameter  
Author Message
Kroll, Michael





PostPosted: 2005-11-3 21:03:00 Top

java-programmer, Oracle Procedure out parameter Hi,

I use a Oracle procedure with some out parameters.
How can I get it from a JSP/JSTL ?

I don't find any samples ....


Regards
Michael
 
marco_giuliani_it





PostPosted: 2005-11-3 23:22:00 Top

java-programmer >> Oracle Procedure out parameter jsp example with cursor out parameter

CallableStatement cstmt = Connconnect_IME.prepareCall("{call
GET_LOCALITY_LIST(?,?,?)}");
//cstmt.setQueryTimeout(QUERY_TIMEOUT);
cstmt.registerOutParameter(3, OracleTypes.CURSOR);
cstmt.setString(1,counties);
cstmt.setString(2,locality);
cstmt.execute();

ResultSet resultsGeo = (ResultSet) cstmt.getObject(3);
boolean resultsGeo_isEmpty = !resultsGeo.next();
boolean resultsGeo_hasData = !resultsGeo_isEmpty;

then you can just get the values from the resultset "resultsGeo" column
names.

this what you need?

 
Kroll, Michael





PostPosted: 2005-11-4 13:26:00 Top

java-programmer >> Oracle Procedure out parameter Hallo,

I try it ....

Thanks