It's working now. Following is the complete list of a sample JSP page
<!-- This program calls a Oracle Stored procedure which has a out
parameter
of type CURSOR. In other words, the stored procedure returns a ResultSet.
-->
<HTML>
<HEAD>
<Title> Testing call of Oracle Stored procedure from JSP</Title>
</head>
<body>
<%@ page language="java" import="java.sql.*, oracle.jdbc.driver.*" %>
<%@ page errorPage="errorpage.jsp" %>
<%
Connection con=null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@xxx.stgeorgeconsulting.com:1521:xxx","xxx","xxx");
CallableStatement call = con.prepareCall ("call
emp_package.open_emp(?,?)");
call.registerOutParameter(1, OracleTypes.CURSOR);
call.setInt(2, 2 );
call.execute();
rs = (ResultSet)call.getObject(1);
while (rs.next()) { %>
<ul>
<li><%=rs.getString("LNAME") %></a></li>
<% }%>
</ul>
<%}
catch (SQLException sqle) {
out.println(sqle.getMessage());
}
finally {
try {
if (con != null){
con.close();
}
}
catch (SQLException sqle) {
out.println(sqle.getMessage());
}
}
%>
</body>
</html>
====================================================================
++ Amarjyoti Das
++ email: [EMAIL PROTECTED]
++ phone: (207) 594-3048 x 23
++ fax:(207) 594-3021
++ web: www.stgeorgeconsulting.com
====================================================================
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
