Error:
FAILURE ORA-28267: Invalid NameSpace Value
ORA-02063: preceding line from SYS00_DEVSCS00
ORA-06512: at "SYS00_UAT.CONTACTINFOMF_TX_TRG", line 4
ORA-04088: error during execution of trigger 'SYS00_UAT.CONTACTINFOMF_TX_TRG'
Trigger Code
create or replace trigger SYS00_UAT.CONTACTINFOMF_TX_TRG
AFTER INSERT OR UPDATE of CONTACT_CD, CONTACT_INFO on SYS00_UAT.CONTACTINFOMF
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
-- test if contact code is Mobile
if :New.CONTACT_CD = 'M' then
insert into SYS00_UAT.MOBILENOTF (CUSTID, CEL_NO, SYSTEM_CODE, TRAN_CODE, MESSAGE)
VALUES(:New.SSNUM, :New.CONTACT_INFO, 'REG', 'REG','Sample Message');
end if;
END;
Background:
Table CONTACTINFOMF is in Oracle 11g. MOBILENOTF is in Oracle 10g. Though Dblink and other configs are seem okay, the error above is still encountered. Based on forums the error needs a database patch to fix this, but of course this will take time and may affect the stable configuration of the table.I am using Java and running on WebLogic Server.
Quick Fix:
I downloaded a ojdbc6.jar on the oracle site, loaded it in my application library. Then voila, works like magic!Hope this helps you!
No comments:
Post a Comment