Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to create object in Oracle 8?
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
![]() |
![]() |