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
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!!
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 ]
Joined: Oct 08, 2003
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