ORA-30926: unable to get a stable set of rows in the source

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: 


Alert Log files show the the following:


ORA-12012: error on auto execute of job 101491
ORA-30926: unable to get a stable set of rows in the source tables
ORA-06512: at "Procedure", line 15


Trace File shows:


/oradg2/orasys/admin/adp2/udump/adp_ora_19344.trc

Comments
--------
*** ACTION NAME:() 2010-01-05 08:15:38.214
*** MODULE NAME:(TOAD 8.5.0.50) 2010-01-05 08:15:38.214
*** SERVICE NAME:(SYS$USERS) 2010-01-05 08:15:38.214
*** SESSION ID:(1509.9559) 2010-01-05 08:15:38.214
*** 2010-01-05 08:15:38.214
ksedmp: internal or fatal error
ORA-30926: unable to get a stable set of rows in the source tables
Current SQL statement for this session:
MERGE INTO HR_IMAGE_IDCARDS D USING (SELECT * FROM ADP_TO_HR_V ) S ON (D.EMP_ID = S.EMP_ID) WHEN MATCHED THEN UPDATE SET D.EMP_PHOTO = S.EMP_PHOTO , D.PERS_ID = S.PERS_ID , D.OBSOLFLAG = S.OBSOLFLAG WHEN NOT MATCHED THEN INSERT (D.EMP_ID, D.EMP_PHOTO , D.PERS_ID, D.OBSOLFLAG) VALUES (S.EMP_ID, S.EMP_PHOTO , S.PERS_ID, S.OBSOLFLAG)
----- PL/SQL Call Stack -----
object line object
handle number name
3cd8b43a0 3 procedure HR.UPDATE_EMP_CARD_PHOTO
3ccaff628 1 anonymous block


Explanation:


You can not update LOB objects remotely throw Database Links
ORA-22992: cannot use LOB locators selected from remote tables


Solution:


Change Business Logic




   

Get Oracle Certifications for all Exams
Free Online Exams.com