Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PB to create member functions for object under ORACLE 8.1.5
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