Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes How to call an Oracle Funtion with my JSP page Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to call an Oracle Funtion with my JSP page" Watch "How to call an Oracle Funtion with my JSP page" New topic
Author

How to call an Oracle Funtion with my JSP page

May Hsiao
Greenhorn

Joined: Aug 13, 2000
Posts: 9
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
Ranch Hand

Joined: Oct 13, 2000
Posts: 297
Here's an example I use in a .jsp, of course it's inside of <% %> tags. Hope it helps.
 
GeeCON Prague 2014
 
subject: How to call an Oracle Funtion with my JSP page