Re: How to create object in Oracle 8?

From: Francis Wong <wongfrancis_at_home.com>
Date: 2000/06/28
Message-ID: <Rew65.30342$7I1.544180@news1.rdc2.on.home.com>#1/1

I know it sounds strange but you need to put a / at the end of PL/SQL block.

"John Wright" <gtaurine_at_hotmail.com> wrote in message news:395A2B62.4DF8732F_at_hotmail.com...
> I tried to create the object example in a book, so I typed
> in SQL*Plus the following:
> create or replace type ADDRESS_TY as object
> (Street VARCHAR2(50),
> City VARCHAR2(25),
> State CHAR(2),
> Zip NUMBER);
>
> After that, SQL*Plus didn't nothing, but showing the next
> line number, seemed like it still awaited my input
>
> what's wrong with this?
>
>
>
Received on Wed Jun 28 2000 - 00:00:00 CDT