Re: HELP! object relational

"Kathrin Holweger" <kaholli_at_web.de> wrote in message news:3b2b4e4b$1_at_netnews.web.de...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> >SQL>
> >SQL> create type body line_t as
> > 2 member function linelength(scale number) return
> > 3 number is
> > 4 begin
> > 5 return
> > 6 scale *
> > 7 sqrt((self.end1.x - self.end2.x)
> > 8 * (self.end1.x - self.end2.x)
> > 9 + (self.end1.y - self.end2.y)
> > 10 * (self.end1.y - self.end2.y));
> > 11 end;
> > 12 end;
> > 13 /
> >
> >Type body created.
> >
> >SQL>
> >SQL> spool off
> >
> >This is Personal Oracle 8.1.5
> >
> >So what is your error again?
>
>
> Actually I thought I was specific. After the "create type body" part I
 always
> got the error, "type created with compilation errors". So obviously I
 couldn't
> access the method because it just wasn't there. but compilation error
 isn't
> really specific and I got that for whatever I did. But if it works for you
 and
> since this is also supposed to be right then maybe it is and there's just
> something wrong with our oracle configuration at uni. But thanks very much
 for
> trying this out for me!!
>
>
> Holli
>
> --
> __________________________________________________________
> News suchen, lesen, schreiben mit http://newsgroups.web.de

There is a show errors command which you should use immediately after receiving ... created with compilation errors message. Later on, select * from user_errors where name = '<object in error>' should provide the full error message.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Jun 16 2001 - 17:25:57 CDT