ORA-31600 Invalid Input Value Storage For Parameter Name In DBMS_METADATA.Function Set_transform_param
(Doc ID 1311567.1)
Last updated on JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.5 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |