Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PB to create member functions for object under ORACLE 8.1.5
Based on your code,
It appears that you never declare VAL2.
Olivier.Nass <Olivier.Nass_at_forenap.asso.fr> wrote in message
news:39255102.4792576E_at_forenap.asso.fr...
> I've ever success to create an object with a member function.
> But with 2 function associated to the same object, it doesn't work.
>
> example :
> CREATE OR REPLACE TYPE essai
> (
> nom VARCHAR2,
> MEMBER PROCEDURE func1
> );
>
> CREATE OR REPLACE BODY TYPE essai AS
> MEMBER PROCEDURE func1 IS
> BEGIN
> NULL;
> END;
> END;
>
> CREATE TABLE essai_t of essai;
>
> DECLARE
> val1 essai;
> BEGIN
> SELECT VALUE(v) into val1 where ...;
> val1.func1(); // OK !!!
> END;
>
> --------------------------------------------------------------------------