Hi Community,
I installed a clean 7.17.0 Oracle version and wanted to import a package from another environment. I tried several times to install it (deleting it, regenerating schemas, compiling, getting back to the VM Snapshot) and it doesn't work.
The installation log prints the following message for almost any of the package's objects (you can find here an example for the "Case" object) :
2022-03-28 16:31:20,550 Error occurred while saving schema database structure "Case" in package "". UId 00000000-0000-0000-0000-000000000000: Error "Invalid parameter binding
Parameter name: NEW" occurred when updating schema structure. SQL script text: "CREATE OR REPLACE TRIGGER "CREATIO"."TR117D32F98275453484111C6611BI"
BEFORE INSERT ON "Case" REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
IF (:NEW."Id" IS NULL) THEN
:NEW."Id" := "tspkg_Utilities"."fn_CreateGuid"();
END IF;
END "TR117D32F98275453484111C6611BI";"
Do you have an idea from where this issue can come from ? The base environment where I exported this specific package is working fine.
"Case" in package "". UId 00000000-0000-0000-0000-000000000000 --> This part seems really strange. It seems like it doesn't find the package where he must install the related object.
Thanks a lot for your help.
Best regards,
Jonathan