my dog learned polymorphism*
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How to call an Oracle Funtion with my JSP page
 
Similar Threads
Swap function in java
Displaying Variable in JSP! Urgent please
Connection Pooling
How to use validWhen
EL function error:The function cannot be located with the specified prefix