Oracle collections!

From: SRIDHARAN, SAN (SBCSI) <ss4569_at_sbc.com>
Date: Thu, 22 Apr 2004 10:11:09 -0700
Message-ID: <D363ADA29513DD4C879B4275920327DE078190@cafrfd1msgusr02.itservices.sbc.com>

Hello List,

We are using Oracle collection to pass data to the JDBC. ( MASTER DETAILS RECORDS). CREATE OR REPLACE VIEW prod_offer_view OF master

    WITH OBJECT id (PROD_OFFER_ID) AS
 SELECT MASTER(m.Prod_offer_id, m.FIRST_EFFECT_DT,

           cast(multiset(SELECT d.PROD_IDEN_ID, d.FIRST_EFFECT_DT
                            FROM PROD_OFFER_IDEN d
                          WHERE d.PROD_OFFER_ID =3D m.PROD_OFFER_ID) AS
DETAILS))
      FROM PROD_OFFER m

 =20
CREATE TYPE DETAIL AS OBJECT(
PROD_IDEN_TYPE_ID NUMBER(5),
 START_DATE DATE); CREATE TYPE DETAILS AS TABLE OF DETAIL; CREATE TYPE MASTER AS OBJECT(
PROD_OFFER_ID NUMBER(10),
START_DATE DATE,
inv_detail DETAILS);

Can any one provide some example on how to access this user defined datatype in JAVA.

Thanks,
San

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Apr 22 2004 - 12:42:37 CDT