member function that prints type_name

Apologies for the double post.

I want to add a member function to an object type that among other things, prints out its own type name from the user_types table.

This bit of code (found in theOracle9i Application Developer's Guide - Object-Relational Features) returns the type name of each customer instance in the table Customer_objtab:

SELECT c.CustName, u.TYPE_NAME
  FROM Customer_objtab c, USER_TYPES u
  WHERE SYS_TYPEID(VALUE(c)) = u.TYPEID;

I've tried something similar in my member function (it compiles), but I get an ORA-01747: invalid user.table.column, table.column, or column specification error when I call it.

Any ideas?

• Assume shape_type has been declared elsewhere CREATE OR REPLACE TYPE BODY shape_type AS MEMBER PROCEDURE display_shape IS v_type VARCHAR(20); BEGIN SELECT u.TYPE_NAME INTO v_type FROM USER_TYPES u WHERE SYS_TYPEID(VALUE(SELF)) = u.TYPEID; -- doesn't work DBMS_OUTPUT.PUT_LINE('Type: ' || v_type); END; / SHOW ERRORS;