aspose file tools
The moose likes JDBC and Relational Databases 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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: How to call an Oracle Funtion with my JSP page
 
It's not a secret anymore!