Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 30+ long db_link names and dbms_metadata.get_ddl
Has anyone run into a problem trying to extract the definition of a
database link, using DBMS_METADATA, where the link name is > 30
characters? Either I'm missing something or I've found another bug in
9.2.0.4. Here's an example:
CREATE DATABASE LINK test_of_a_long_database_link_name USING 'sid1';
SET ECHO off FEEDBACK off HEADING off LINESIZE 2047 LONGCHUNKSIZE 2047 LONG 32767 PAGESIZE 0 SCAN off
SET SQLBLANKLINES on TAB off
COLUMN stmt WORD_WRAPPED
EXECUTE
dbms_metadata.set_transform_param(DBMS_METADATA.SESSION_TRANSFORM,'SQLTE
RMINATOR',TRUE);
SELECT
dbms_metadata.get_ddl('DB_LINK','TEST_OF_A_LONG_DATABASE_LINK_NAME','DHE
RRI') stmt
FROM dual;
... and the output is:
ORA-31600: invalid input value LONGNAME for parameter NAME in function SET_FILTER ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 1980
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3665
ORA-06512: at "SYS.DBMS_METADATA", line 670
ORA-06512: at "SYS.DBMS_METADATA", line 571
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1
If I change the database link name to ' test_of_a_long_database_link_n' it works fine.
Any clues?
Dave
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com <mailto:dherri_at_acxiom.com> >
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 26 2005 - 09:22:24 CDT