DBMS_METADATA.GET_DDL(<paramName>=>'<value>'...) returns ORA-00907

[Spendius]

I always get a "missing right parenthesis" error message as soon
as I try to use this function by specifying parameters:

> select
> DBMS_METADATA.GET_DDL(object_type=>'VIEW', name=>'MQOT_V')
> from dual;
> DBMS_METADATA.GET_DDL(object_type=>'VIEW', name=>'MQOT_V')
> *
> ERROR at line 2:
> ORA-00907: missing right parenthesis

but:
> select
> DBMS_METADATA.GET_DDL('VIEW', 'MQOT_V') from dual;
>
> DBMS_METADATA.GET_DDL('VIEW','MQOT_V')
> --------------------------------------
>
> CREATE OR REPLACE VIEW [...]

Can someone help me please ?
Thks.
Spendius

[Anurag Varma]

named notation for calling functions in SQL is not supported (i.e. not
a valid syntax).
This still does not work in the 10g. Maybe in future version.....

So, you have to use the 2nd method of calling functions in SQL.

Anurag