Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00600 ... internal error code ...

617891Apr 11 2008 — edited Apr 11 2008
ORA-00600: internal error code, arguments: [2865], [3003], [3000], [34570

I am getting this error saying like Suppression error .Pleas some one tell me can I neglect this ORA-00600 error ...or i need to consider ...

Thu Apr 10 09:16:07 2008 Starting Process SUPPRESS: 1981 ( id=88764184 priority=0 client=8220280 retry=1 )



fail

Thu Apr 10 09:43:46 2008 DBD::Oracle::st execute failed: ORA-00600: internal error code, arguments: [2865], [3003], [3000], [34570], [], [], [], []ORA-06512: at line 44 (DBD ERROR: OCIStmtExecute) [for Statement " DECLARE TYPE profile_id_tab IS TABLE OF subscriber_tbl.profile_id%TYPE; xprofile_id_tbl profile_id_tab := profile_id_tab(); suppress PLS_INTEGER := 0; scan PLS_INTEGER := 0; skip_flg PLS_INTEGER := 0; suppress_flg PLS_INTEGER := 0; source_block_id PLS_INTEGER := 0; target_block_id PLS_INTEGER := 0; source_list_id PLS_INTEGER := 0; target_list_id PLS_INTEGER := 0; target_plist_id PLS_INTEGER := 0; xidx PLS_INTEGER := 0; BEGIN SELECT ?, ?, ?, ?, ?, ?, ? INTO source_block_id, target_block_id, source_list_id, target_list_id, target_plist_id, suppress_flg, skip_flg FROM DUAL; IF skip_flg = 0 THEN INSERT INTO sup_t1981_1207833370 SELECT s.profile_id, LOWER(TRIM(p.profile_key)), s.block_id FROM subscriber_tbl p, sendq_tbl s WHERE p.profile_id = s.profile_id AND s.slist_id = target_list_id AND s.block_id = target_block_id AND p.plist_id = target_plist_id; scan := SQL%ROWCOUNT; COMMIT; END IF; SELECT t.profile_id BULK COLLECT INTO xprofile_id_tbl FROM sup_s1981_1207833370 s, sup_t1981_1207833370 t WHERE s.sup_key = t.sup_key AND t.block_id = target_block_id; suppress := xprofile_id_tbl.COUNT; IF suppress_flg = 1 AND xprofile_id_tbl.COUNT > 0 THEN FORALL xidx IN xprofile_id_tbl.FIRST .. xprofile_id_tbl.LAST DELETE FROM sendq_tbl WHERE slist_id = target_list_id AND profile_id = xprofile_id_tbl(xidx); IF SQL%ROWCOUNT > 0 THEN COMMIT; END IF; END IF; SELECT suppress, scan INTO ?,? FROM DUAL; END; " with ParamValues: :p5='30025434', :p6='1', :p3='71444031', :p7=0, :p1='1', :p8=0, :p4='71444058', :p9=10000, :p2='7664116'] at /export/home/bfiapps/cvs/dream3x/common/List/Suppression.pm line 232, <DATA> line 855.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2008
Added on Apr 11 2008
2 comments
485 views