OraFAQ Forum: Client Tools » Why doesn't this work ?

Home » Other » Client Tools » Why doesn't this work ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Why doesn't this work ? [message #38618]

Tue, 30 April 2002 17:12

Yogita
Messages: 8
Registered: April 2002

Junior Member

Hi !!!

This is the example given in the oracle 9i documentation.

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88878/adobjbas.htm#454999

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;

I am not able to create the table type nt_pl_t. Can anyone help me ?

Thanks
Yogita

Report message to a moderator

Re: Why doesn't this work ? [message #38626 is a reply to message #38618]

Wed, 01 May 2002 07:18

oraboy
Messages: 97
Registered: October 2001

Member

Whats your error when u tried doing this?

Oraboy

Report message to a moderator

Re: Why doesn't this work ? [message #38630 is a reply to message #38618]

Wed, 01 May 2002 10:28

oraboy
Messages: 97
Registered: October 2001

Member

This is what documentation says.,
Cause: An attempt was made to do one of the following: define a table type
which contained nested collection types. or define an object table
that has (perhaps nested) another table type or VARRAY type.
Action: Check the table definitions to be sure that they do not contain
nested tables or VARRAYs.

Probably, your code shud have been like this ..

CREATE TYPE planet_t AS OBJECT (
name VARCHAR2(20),
mass NUMBER,
satellites satellite_t );

Oraboy

Report message to a moderator

Re: Why doesn't this work ? [message #38635 is a reply to message #38618]

Wed, 01 May 2002 20:54

Yogita
Messages: 8
Registered: April 2002

Junior Member

But this is an example in the oracle 9i documentation. I just borrowed from that. My previous mail has the link to the example in oracle docs.

Is there any other way to represent this nested collection types?

Thanks
-Yogita

Report message to a moderator

Previous Topic:	select in a decode
Next Topic:	I am perplexed on how to do this...pls help...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 10:36:31 CST 2025