RE: PL/SQL return a ref cursor to Java client

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 01 May 2002 09:58:35 -0800
Message-ID: <F001.0045517F.20020501095835@fatcity.com>

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
luckyref_at_yahoo.com

---

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: luckyref_at_yahoo.com

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: ListGuru_at_fatcity.com (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: Waleed.Khedr_at_FMR.COM

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: ListGuru_at_fatcity.com (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). Received on Wed May 01 2002 - 12:58:35 CDT