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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to create object in Oracle 8?

Re: How to create object in Oracle 8?

From: Francis Wong <wongfrancis_at_home.com>
Date: 2000/06/29
Message-ID: <RaR65.31586$7I1.575551@news1.rdc2.on.home.com>#1/1

Check those examples in chapter 16 of application developer guide. So far, I don't see where Oracle manual mention this scenario.

"John Wright" <gtaurine_at_hotmail.com> wrote in message news:395B3D7B.E6BB7395_at_hotmail.com...
> Oh, great! Why the book doesn't tell this? I should put a / at end of each
> object or whole object cluster?
> Where can I find such information?
>
> Thanks!
>
> John
>
> Francis Wong wrote:
>
> > 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 Thu Jun 29 2000 - 00:00:00 CDT

Original text of this message

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