I wasn't going to respond to this, thinking that you'd just made a
slip up or it was just not worthwhile correcting your ignorance. But
then I read some of your other supercilious responses on this group
and couldn't resist. If you don't have any helpful answers, or just
something arrogant to say, just don't respond.
Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<1ni6fvk7vj7bkqs222ac1t47uahnh53870_at_4ax.com>...
> 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 Sun Jun 22 2003 - 18:54:34 CDT
