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: PB to create member functions for object under ORACLE 8.1.5

Re: PB to create member functions for object under ORACLE 8.1.5

From: kmposter <kmomon1_at_san.rr.com>
Date: 2000/05/19
Message-ID: <LpdV4.15963$Y4.67974@typhoon2.san.rr.com>#1/1

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;
>
> --------------------------------------------------------------------------



>
> With 2 functions it doesn't work !!!
> CREATE OR REPLACE TYPE essai
> (
> nom VARCHAR2,
> MEMBER PROCEDURE func1,
> MEMBER PROCEDURE func2
> );
>
> CREATE OR REPLACE BODY TYPE essai AS
> MEMBER PROCEDURE func1 IS
> BEGIN
> NULL;
> END;
> MEMBER PROCEDURE func2 IS
> BEGIN
> NULL;
> END;
> END;
>
> DECLARE
> val1 essai;
> BEGIN
> SELECT VALUE(v) into val1 where ...;
> val1.func1(); // ERROR !!!
> val2.func2(); // ERROR !!!
> END;
>
> Have someone an explication or concrete exemple which work under ORACLE
> 8.1.5
>
Received on Fri May 19 2000 - 00:00:00 CDT

Original text of this message

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