Hi! Everybody,
I know that this might be off topic but I'm doing servlet prog and faced this
prob in the midst of it.
I and using Oracle 8i a backend.
I want to know how I can return multiple records that are formed as result of
processing in the SP.
I call the SP as follows:
CallableStatement callSt = connection.prepareCall("CALL PADD(.....)");
callSt.registerOutParameter(1, java.sql.Types.INTEGER);
rsp = callSt.executeQuery();
At the end of the above mentioned calls I want to have rsp (my resultset) to
be populated with multiple records that are formed in the SP.
At present I write the values in a temp table, read the values by another call
to executeQuery and delete values from this temp table.
Please suggest modifations to the stored procedure and JDBC code to give
better control on what a call to executeQuery can return when used as above.
Thanks in anticipation,
Ajay.
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
___________________________________________________________________________
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
