of course yes you can store them


CREATE OR REPLACE TYPE Dummy AS OBJECT (
f1 NUMBER,
f2 NUMBER,
MEMBER PROCEDURE Method1(x IN VARCHAR2),
MEMBER FUNCTION Method2 RETURN DATE
);
/

an object is created with attributes as f1 & f2 and 2 member functions.

-- Create the type body.
CREATE OR REPLACE TYPE BODY Dummy AS
MEMBER PROCEDURE Method1(x IN VARCHAR2) IS
BEGIN
NULL;
END Method1;

MEMBER FUNCTION Method2 RETURN DATE IS
BEGIN
RETURN SYSDATE;
END Method2;
END;
/

COLUMN object_name FORMAT a20

SELECT object_name, object_type, status
FROM user_objects
WHERE object_name = 'DUMMY';


i hope i answer your question this time......





[Edited by hrishy on 04-11-2001 at 04:56 AM]