My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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:



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



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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.