User defined TYPEs

From: Andrey Bronfin <bronfin_at_VisualTop.com>
Date: Wed, 13 Sep 2000 20:52:05 +0200
Message-Id: <10618.116870@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_000F_01C01DC4.79A11810 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear List !

I need to define a user-defined TYPE X that contains objects of the = same TYPE X ( recursively ) .
i also need to define a type A that contains objects of another type B , = which contains objects of type A .

For example i need something like :

create type button_obj as object ( name varchar2(10) , action = varchar2(10) , buttons_list ) ;

And the buttons_list is=20

create type buttons_list as table of button_obj ;

I did not find a way to do it :( .

It looks like the type "buttons_list" must be already defined prior to = defining of "button_obj"=20
and "button_obj" must be already defined prior to defining of = "buttons_list" .

What should i do ?

Any ideas will be greatly appreciated .

Thanks a lot in advance .

Andrey Bronfin
VisualTop.com

------=_NextPart_000_000F_01C01DC4.79A11810 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#d4d0c8>
<DIV><FONT face=3DArial size=3D2>Dear List !</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I need to define a user-defined =
TYPE  X that=20
contains objects of the same TYPE  X ( recursively ) .</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>i also need to define a type A that =
contains=20
objects of another type B , which contains objects of type A = .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>For example i need something like =
:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>create type button_obj as object ( name =

varchar2(10) ,  action varchar2(10) , buttons_list ) ;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>And the buttons_list is </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>create type buttons_list as table of=20
button_obj  ;</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I did not find a way to do it :( =20
.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>It looks like the type "buttons_list" =
must be=20
already defined prior to defining of "button_obj" </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and "button_obj"  must be already =
defined=20
prior to defining of  "buttons_list" .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>What should i do ?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any ideas will be greatly appreciated=20
.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks a lot in advance .</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>Andrey=20
Bronfin<BR>VisualTop.com<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2> </DIV></FONT>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR></FONT> </DIV></BODY></HTML>
Received on Wed Sep 13 2000 - 13:52:05 CDT