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

PB to create member functions for object under ORACLE 8.1.5

From: Olivier.Nass <Olivier.Nass_at_forenap.asso.fr>
Date: 2000/05/19
Message-ID: <39255102.4792576E@forenap.asso.fr>#1/1

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