Question about article of "ObjectTypes"

[Guest]

I tried the example at http://www.oracle-base.com/articles/8i/object-types.php. I got an error when I tried to do:
SELECT p.id,
p.person.first_name,
p.person.getAge() age
FROM people p;

The error message is:
ORA-06571: Function GETAGE does not guarantee not to update database

How to avoid this error message?

[Tim...]

My guess is you are using an earlier version of 8i, not 8.1.7. In the later versions of 8i the need to specify purity levels was removed. Try this:

CREATE OR REPLACE TYPE PersonObj AS OBJECT (
first_name VARCHAR2(50),
last_name VARCHAR2(50),
date_of_birth DATE,
MEMBER FUNCTION getAge RETURN NUMBER,
PRAGMA RESTRICT REFERENCES(getAge, WNDS)
);
/

This states that the member function getAge Writes No Databased State.

Check out the discussion of purity levels:

http://otn.oracle.com/docs/products/ora ... tm#2064466
http://otn.oracle.com/docs/products/ora ... tm#1014698