Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

The MEMBER FUNCTION clause declares the getByDate() function

You can declare a procedure using MEMBER PROCEDURE. A procedure is similar to a function except that a procedure doesn't typically return a value CREATE Or Replace TYPE ProductType AS OBJECT (   id          NUMBER,   name        VARCHAR2(15),   description VARCHAR2(22),   price       NUMBER(5, 2),   days_valid  NUMBER,   MEMBER FUNCTION getByDate RETURN DATE ); /