Hi,

I'm trying to use DBMS_METADATA to get the DDL:

SELECT TO_CHAR(DBMS_METADATA.GET_DDL('TABLE',
o.name,'DATA_HOLDER')) ddl_string
FROM sys.obj$ o,sys.tab$ t
WHERE o.owner# = 28
AND o.obj# = t.obj#
AND BITAND(o.flags, 128) = 0;



ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion
(actual: 4747, maximum: 4000)


I cannot seem to get around that error no matter what I try. Any
suggestions?

Thanks!

The Magnet <art (AT) unsu (DOT) com> wrote:

Why are you using TO_CHAR on it? You should be able to read the result
without that.

--
__________________________________________________ _____________________
Dan Blum tool (AT) panix (DOT) com
"I wouldn't have believed it myself if I hadn't just made it up."

On Apr 1, 3:04*pm, The Magnet <a... (AT) unsu (DOT) com> wrote:
The more appropriate response is: you really need to learn data
types and their sizes. VARCHAR2 (used by to_char) has a maximum size
of 4000 bytes as stated by the error message.

see: http://asktom.oracle.com/pls/asktom/...D:367980988799
for an example of how to retrieve a clob into something useful.