Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Please help:Can't create sql object types

Please help:Can't create sql object types

From: Alvaro Fuentes <alvarof2_at_hotmail.com>
Date: Mon, 22 Oct 2001 23:52:05 GMT
Message-ID: <Fi2B7.2932$Zz.427599@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

  1. Fuentes afuentes_at_goodpremises.com (512)297-9937
Received on Mon Oct 22 2001 - 18:52:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US