using DBMS_METADATA.GET_DDL with table name containing a single quote

Hi,

I have a table named "Hi$Schema's" in my schema 'myschema'.

However, if I try the following sql statement, I get a failure message.

SELECT DBMS_METADATA.GET_DDL('TABLE','Hi$Schema''s','myschema') FROM dual

The error mesesage is:

ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-06512: at "SYS.DBMS_XMLGEN", line 83
ORA-06512: at "SYS.DBMS_METADATA", line 345
ORA-06512: at "SYS.DBMS_METADATA", line 410
ORA-06512: at "SYS.DBMS_METADATA", line 449
ORA-06512: at "SYS.DBMS_METADATA", line 615
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1

I don't know how to deal with this single quote.

Does anyone know a solution or a workaround? Received on Wed Apr 18 2007 - 15:57:39 CDT