Graham Heath

Greenhorn
+ Follow
since Oct 08, 2003
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Graham Heath

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
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