You can make an out parameter which is a cursor, or probably also one which is an array if you'd rather. Once you get the cursor at the client it's pretty easy to turn it into a ResultSet in JDBC and then process it just like you would any other.
Cheers -----Original Message----- From: Abu dhahir To: [EMAIL PROTECTED] Sent: 10/17/01 12:29 AM Subject: getting resultset from stored procedure - oracle Hi gurus is there a way that i can receive a resultset or array from stored procedure of oracle. i want to receive a cursor generated or the rows collection generated in that procedure cheers abu Iron rusts from disue; stagnant water loses its purity and in cold weather becomes frozen; even so does inaction sap the vigor of the mind. Leonardo da Vinci (1452 - 1519), The Notebooks ======================================================================== === To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help". =========================================================================== To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff EJB-INTEREST". For general help, send email to [EMAIL PROTECTED] and include in the body of the message "help".
