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 -> Re: Why can't I have an object with no attributes?

Re: Why can't I have an object with no attributes?

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Thu, 12 Jun 2003 08:17:05 +0200
Message-ID: <bc960d$gfq9r$1@ID-152732.news.dfncis.de>


Hi, Richard,

just curious:
why donīt You just use a function for that purpose ? That is what stored procedures are for since long ago.

Create or replace function foobar
return varchar2
as
...
begin
...
end;

Jan

"Richard Kuhler" <noone_at_nowhere.com> schrieb im Newsbeitrag news:o1LFa.48388$49.1470796_at_twister.socal.rr.com...
> Why can't I have an object with no attributes? How else can I make an
> interface definition? How can I extend an object with additional
> methods but no additional attributes?
>
>
> For example ...
>
> create or replace type tobj is object (
> member function foobar
> return varchar2
> );
> /
>
> show errors
>
> PLS-00589: no attributes found in object type "TOBJ"
>
>
> Thanks,
> Richard
>
Received on Thu Jun 12 2003 - 01:17:05 CDT

Original text of this message

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