Re: problems with dbms_metadata

Ecce Nihil wrote:

> 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

People that live in glass houses should not throw stones.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)