How to call an Oracle Funtion with my JSP page

[May Hsiao]

I implement a funtion in Oracle and how can I get the funtion return value into a JSP variable?
I read API document for Connection.prepareCall & CallableStatement.registerOutParameter & CallableStatement.setString, CallableStatement.getString, but I cannot find an example for using these method!!!
Help!! Help!!!

[Michael Hildner]

Here's an example I use in a .jsp, of course it's inside of <% %> tags. Hope it helps.

CallableStatement cs = con.prepareCall("{? = call X2K.pkgOrderType.getOrderTypes(?, ?, ?, ?)}");
cs.registerOutParameter(1, java.sql.Types.OTHER);
cs.setString(2, codeInTable);
cs.setString(3, exchangeCode);
cs.setString(4, futureOptionSwitch);
cs.setString(5, tradingSession);
cs.execute();
ResultSet rs = (ResultSet)cs.getObject(1);

while (rs.next())
{
...