permaculture playing cards*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 60048
    
  65

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: 15286
    
    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 - A Test Data Generation Platform
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60048
    
  65

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
 
Similar Threads
printing to server console
Multiple result sets possible with Oracle?
Can any one help me how can i connect oracle9i with odbc
Problem withUpdatable Resultset
Run dynamic sql in stored procedure problem