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

From: Spendius <spendius_at_muchomail.com>
Date: 18 Feb 2005 06:21:44 -0800
Message-ID: <aba30b75.0502180621.2e11dda@posting.google.com>

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 Received on Fri Feb 18 2005 - 08:21:44 CST