Skip to Main Content

SQLcl

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error when running project stage (ORA-31600)

Suddenly staging has en error, I have made a handful successful export/stage/release/deploy runs with this setup.

The command is “project stage”.

ERROR: An error has occurred processing your request:
ORA-31600: invalid input value REF_CONSTRAINT for parameter OBJECT_TYPE in function OPENC
ORA-06512: at "SYS.DBMS_METADATA_DIFF", line 471
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA_DIFF", line 445
ORA-06512: at line 130

https://docs.oracle.com/error-help/db/ora-31600/

REF_CONSTRAINT seems to be valid to me. It is created byt export so it should be…

Any idea how to fix and get it back in proper shape?

Running in Windows with version 24.3 of SQLcl.

This post has been answered by heraoui-Oracle on Jun 2 2025
Jump to Answer
Comments
Post Details
Added on Jun 2 2025
4 comments
94 views