This content has been marked as final. Show 1 reply
SQL Error: ORA-31600: invalid input value BASE_OBJECT_NAME for parameter NAME in function SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_INT", line 2040
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4058
ORA-06512: at "SYS.DBMS_METADATA", line 670
ORA-06512: at "SYS.DBMS_METADATA", line 583
ORA-06512: at "SYS.DBMS_METADATA", line 1282
ORA-06512: at line 1
31600. 00000 - "invalid input value %s for parameter %s in function %s"
*Cause: A NULL or invalid value was supplied for the parameter.
*Action: Correct the input value and try the call again.
SELECT TRIM(TO_CHAR (DBMS_METADATA.get_dependent_ddl('TABLE','FND_APPLICATION','APPLSYS'))) string
what is the problem in this query..
Please mark this question ANSWERED as you have posted it in the wrong forum. This forum is ONLY for SQL Developer questions.
You are trying to use the 'get_dependent_ddl' function to query 'tables' that are dependent on some object name 'FND_APPLICATION').
Tables are NOT dependent objects. Review table 74-11 in the DBMS_METADATA chapter of the Packages and Types doc
Again - mark this question ANSWERED and if you want any other input you need to repost it in the proper forum.