This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to call an Oracle Funtion with my JSP page
 
It's not a secret anymore!