Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP and Oracle Functions

 
Graham Heath
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!!
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64824
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum.
bear
 
Gregg Bolinger
GenRocket Founder
Ranch Hand
Posts: 15302
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64824
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic