we are using multiple PDB's so we are using DATABASE LINKS for all types of DML operations… when trying to Save a record it is throwing below error:
ORA-02069: global_names parameter must be set to TRUE for this operation
above error occured while trying to insert through my custom app created using Laravel but when inserting using SQL Command in Apex it Save record and showing when Query it.
– ===========================================
DDL
CREATE TABLE "HR_EMP_ADDLESS_UPL"
( "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 99999999 INCREMENT BY 1 START WITH 739 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"EMPNO" VARCHAR2(12) NOT NULL ENABLE,
"SALARY_MONTH" VARCHAR2(10) NOT NULL ENABLE,
"DATE_OF_JOINING" DATE,
"ACTUAL_SALARY" NUMBER DEFAULT 0,
"THE_INCREMENT" NUMBER DEFAULT 0,
"EFFECTIVE_FROM" DATE,
"BASIC_SALARY_AFTER_INCREMENT" NUMBER DEFAULT 0,
"ADD_OTHERS" NUMBER DEFAULT 0,
"LESS_OTHERS" NUMBER DEFAULT 0,
"NOTES_FOR_ADD_LESS" VARCHAR2(255),
"IS_LOCKED" VARCHAR2(1) DEFAULT 'N',
"CREATED_AT" DATE DEFAULT sysdate,
"CREATED_BY" VARCHAR2(255),
"UPDATED_AT" DATE,
"UPDATED_BY" VARCHAR2(255),
"CAMPUS_CODE" VARCHAR2(6 CHAR) DEFAULT '01'
) ;
ALTER TABLE "HR_EMP_ADDLESS_UPL" ADD CONSTRAINT "HR_EMP_ADDLESS_UPL_HR_EMP_EMPNO_FK" FOREIGN KEY ("EMPNO")
REFERENCES "HR_EMP" ("EMPNO") ON DELETE CASCADE ENABLE;
CREATE UNIQUE INDEX "UNQIDX1_HR_EMP_ADDLESS_UPL" ON "HR_EMP_ADDLESS_UPL" ("SALARY_MONTH", "EMPNO")
– ===========================================
Run below PL code to test insert:
declare
ret_msg varchar2(200);
l_clob CLOB;
l_blob BLOB;
v_samp varchar2(1) := 'N';
begin
l_clob :=
'[
{"salary_month":"2025-02",
"empno":"20421",
"emp_name":"AbcdEfgh",
"date_of_joining":"2025-02-04",
"actual_salary":"18000",
"the_increment":null,
"effective_from":null,
"basic_salary_after_increment":"10159",
"add_others":"1800",
"less_others":"1800"
}
]';
l_blob := APEX_UTIL.CLOB_TO_BLOB(p_clob => l_clob);
ret_msg := hr_emp_addless_create (l_blob);
htp.print(ret_msg);
exception
when others then
htp.print(ret_msg);
end;
Employee Add Less Increment Updated Successfully ...
select * from hr_emp_addless_upl@PDBNEWHR where empno = 20421;
– ===========================================
please help how to resolve this problem in this situation
ORA-02069: global_names parameter must be set to TRUE for this operation
with kind regards