aspose file tools*
The moose likes JDBC and the fly likes JSP and Oracle Functions Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JSP and Oracle Functions" Watch "JSP and Oracle Functions" New topic
Author

JSP and Oracle Functions

Graham Heath
Greenhorn

Joined: Oct 08, 2003
Posts: 2
Hello,
I am very new to JSP and Oracle but have loads of experience in ASP.net and SQL Server/Sybase. In many ASP/SQL Server applications that I have built in the past, I create stored procedures to return data out to the calling application and insert the result into a recordset within the calling application. Being new to Oracle, I am looking for a way to perform the same. I believe that I have to use a function to return some for of recordset back out to the calling JSP application, but am unsure how. If anyone has any samples or guidance, it would be wholey appreciated.
Thanks
DH
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Gray TheDatahound
Welcome to the Java Ranch, we hope you�ll enjoy visiting as a regular however, your name is not in keeping with our naming policy here at the ranch. Please change your display name to an appropriate name as shown in the policy.
Thanks again and we hope to see you around the ranch!!


Dave
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61434
    
  67

Moving to the JDBC forum.
bear


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

So are you wanting to know how to get Data from the Database or are you wanting to know how to pass that information that you got back to the calling JSP page?


GenRocket - Experts at Building Test Data
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61434
    
  67

This is the part:
I create stored procedures to return data out to the calling application and insert the result into a recordset within the calling application. Being new to Oracle, I am looking for a way to perform the same.

where I can't really tell what it is you are asking about. Could you elaborate? Are you unsure how to use JDBC to get a resultset? To access stored procedures?
bear
[ October 14, 2003: Message edited by: Bear Bibeault ]
Graham Heath
Greenhorn

Joined: Oct 08, 2003
Posts: 2
For instance,
I have created an oracle function that returns a CLOB. This clob contains a super long html string that was built using certain data components from the database. I want to be able to insert this string into a jsp page. I am unsure how to:
1. Connect to the database.
2. Call the function.
3. Capture the resultset (or resulting error message)
4. Place the resultset into my page.
Thanks, the help is appreciated.
Graham
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSP and Oracle Functions