Database Administration (MOSC)

MOSC Banner

DBMS_METADAT.PUT results in LPX-00210 / ORA-06502

edited Aug 13, 2009 7:37PM in Database Administration (MOSC) 4 commentsAnswered
Hallo,
I am trying to enable ROWDEPENDENCIES for all tables of a schema by a help of a self written package wich uses DBMS_METADATA.
I am able to get the DDL of the table in a clob variable and manipulate that ddl to rename the table.
But when I try to generate the table with the overloaded funtion DBMS_METADATA.PUT i get.

I searched in the documentation and the examples from Oracle, searched the internet and so on but didn't find anything that helped.

Database Version is Oracle XE

Here is the code of interest:

DECLARE
 doc CLOB;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center