What complications ? REF CURSOR to JAVA is really easy using 'ResultSet' Regards,
Waleed -----Original Message----- Sent: Wednesday, May 01, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Hi gurus, Oracle 816, java application. I had a discussion with my co-workers on where all the SQL statements should reside. In client code (java) or in stored procs called by the java client? It's an internet application, so basically they're only a 'select' statements. Some of us prefer to keep all the SQL statements in stored procs, but with this solution comes some technical issues. For Example : Returning resultsets from pl/sql stored procs to the java client. We have to create a pl/sql package, that returns a ref cursor, handles it as a object in java, etc ... it's more complicated than coding an SQL statement directly in the java client. Do you guys have a solution that may be less complicated for this example? If we are going to keep all the SQL statement in stored procs called by the java client, will we have others surprises? TIA Luc ===== Luc Demanche [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Luc Demanche INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).