Re: problems with dbms_metadata

"bung ho" <bung_ho_at_hotmail.com> wrote in message news:567a1b1.0306231239.35843600_at_posting.google.com...

> i'm confused tho, what's wrong with selecting a function? have i been
> doing something wrong all this time?

You didn't do anything wrong, dbms_metadata.get_ddl is a function, hence

    select dbms_metadata.get_ddl(<object_type>, <name>) from dual;

is a perfectly legitimate way of retrieving its value.

Bye,
Flavio Received on Mon Jun 23 2003 - 16:40:47 CDT