Tuesday, June 16, 2015

Invalid Namespace Value ORACLE TRIGGER

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