You have city listed twice. Can't do that.
I get pls-00410 when I run your example.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Alvaro Fuentes" <alvarof2_at_hotmail.com> wrote in message
news:Fi2B7.2932$Zz.427599_at_typhoon.austin.rr.com...
>
> Fellow Oracler's,
>
> This is a case in Solaris8, running Oracle Enterprise Server 8.1.7.0.0
>
> If I do a simple:
>
> SQL> create type t_address as object (
> 2 street varchar2(15), city varchar2(15),
> 3 city varchar2(15), state char(2),
> 4 zip varchar2(9) );
> 5 /
>
> The Oracle Server comes with:
>
> "Error at line 1
> ORA-06544: PL/SQL internal error. Arguments [2603], [], [], [], [], [],
[],
> []
> ORA-06553: PLS-707: Unsupported construct or internal error [2603]"
>
> Any clue about how to solve this problem will be greatly
> appreciated.
>
> Thanks
>
> A. Fuentes
> afuentes_at_goodpremises.com
> (512)297-9937
>
>
>
>
>
Received on Tue Oct 23 2001 - 09:42:22 CDT
