Hi,

In my jsp page I am trying to get the resultset back from a oracle stored
procedure.  The signature of the stored procedure is
PROCEDURE open_emp (c_emp IN OUT emp_cursor,
                        select_type IN NUMBER);
Here the emp_cursor is a REF CURSOR.

In my jsp page I use the following statement to call this procedure
CallableStatement call = con.prepareCall ("call
emp_package.open_emp(?,?)");

Now, what do I do from here to get the resultset from the oracle procedure
to my JSP page?

Thank you,
- Amar

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

Reply via email to