ORA-31600 Invalid Input Value Storage For Parameter Name In DBMS_METADATA.Function Set_transform_param (Doc ID 1311567.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 31-Jan-2014***

Symptoms

Executing a store procedure that makes call to DBMS_METADATA.SET_TRANSFORM_PARAM fails with:

"ORA-31600: invalid input value STORAGE for parameter NAME in function SET_TRANSFORM_PARAM"

when executing a statement similar to the following:

DBMS_METADATA.SET_TRANSFORM_PARAM (th,'STORAGE',false);

 

Example Exception Stack:

 

ERROR at line 1:
ORA-31600: invalid input value STORAGE for parameter NAME in function SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 8040
ORA-06512: at "SYS.DBMS_METADATA_INT", line 8011
ORA-06512: at "SYS.DBMS_METADATA_INT", line 9097
ORA-06512: at "SYS.DBMS_METADATA", line 3431
ORA-06512: at "SYS.GET_SCHEMA_MD2", line 21
ORA-06512: at line 1

 

Changes

Making a call to DBMS_METADATA.SET_TRANSFORM_PARAM with the STORAGE clause.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms