problems with dbms_metadata

I'm having problems using dbms_metadata.get_ddl. I have a table called agreements with the following entry out of user_objects...

select OBJECT_NAME,OBJECT_TYPE,STATUS from user_objects where object_name='AGREEMENTS';

OBJECT_NAME OBJECT_TYPE STATUS

-------------- ------------------ -------
AGREEMENTS     TABLE              VALID

Then I execute...

select dbms_metadata.get_ddl('TABLE','AGREEMENTS') from dual

and get...

ORA-31603: object "AGREEMENTS" of type TABLE not found in schema "MY_SCHEMA" Any ideas?

thanks Received on Fri Jun 20 2003 - 00:36:13 CDT