Multilevel Collection Types in PL/SQL Web Service
From: Dicits2 <dictis2_at_tue.nl>
Date: Mon, 1 Nov 2004 13:52:26 +0100
Message-ID: <cm5bia$2hc$1_at_news.tue.nl>
Hello,
Date: Mon, 1 Nov 2004 13:52:26 +0100
Message-ID: <cm5bia$2hc$1_at_news.tue.nl>
Hello,
is it possible to make a Web Service which returns a multilevel collection
using a PL/SQL Web Service in JDeveloper 10g and an Oracle 9i database?
just like this example from "Oracle9i Application Developer's Guide -
Object-Relational Features
Release 2 (9.2)"
CREATE TYPE satellite_t AS OBJECT (
name VARCHAR2(20),
diameter NUMBER);
CREATE TYPE nt_sat_t AS TABLE OF satellite_t;
CREATE TYPE planet_t AS OBJECT (
name VARCHAR2(20),
mass NUMBER,
satellites nt_sat_t);
CREATE TYPE nt_pl_t AS TABLE OF planet_t; Received on Mon Nov 01 2004 - 13:52:26 CET