Re: problems with dbms_metadata

On 19 Jun 2003 22:36:13 -0700, sct_at_picknowl.com.au (Ecce Nihil) wrote:

>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

Evidently this must be a procedure. Not sure why you are calling in a redundant select.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jun 20 2003 - 12:57:26 CDT