Pls-00801 Internal Error Assert
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter
Pls-00801: Internal Error [phdcsql_print_kge_errors::parm Pos]
a title. You can not post a blank message. Please type your pls 00801 internal error phdite node kind message and try again. More discussions in PL/SQL and SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion pls 00801 internal error 10902 is archived 4 Replies Latest reply on Jul 10, 2013 11:39 PM by rp0428 Execute Immediate with FORALL Debadatta Kar Jul 10, 2013 7:17 PM Hello All,I am running the
Pls-00801 Internal Error 1401
following pl/sql block and getting error as given below:DECLARE CURSOR C1 IS SELECT 'DELETE FROM '||(CASE(rnw.module_name) WHEN 'PSIRT' THEN 'r_psirt_wh_excep WHERE psirt_wh_id=' WHEN 'CBP' THEN 'r_cbp_wh_excep WHERE cbp_wh_id=' WHEN 'CCF' THEN 'r_ccf_wh_excep WHERE ccf_wh_id=' WHEN 'SLG' THEN 'r_slg_wh_excep WHERE slg_wh_id=' WHEN 'CNA' THEN 'r_cna_wh_excep WHERE cna_wh_id=' WHEN 'SIAR' THEN 'r_siar_wh_excep WHERE siar_wh_id=' WHEN 'EOX' THEN 'r_eox_wh_excep WHERE eox_wh_id=' WHEN 'FN' THEN 'r_fn_wh_excep WHERE fn_wh_id=' WHEN 'MANUAL' THEN 'r_manual_wh_excep WHERE manual_wh_id=' END) || rnw.module_wh_id delete_stmt FROM r_nip_wh rnw WHERE rnw.nip_wh_id IN (24414932,24417670,24415041,24420904,24418207,24412051,24418725) AND rnw.party_id = 81714 AND EXISTS (SELECT 1 FROM r_nip_status_mas rnsm WHERE rnsm.status_id = rnw.status_id AND rnsm.status_name IN ('Internal - Resolved', 'Appears Resolved', 'Internal - Appears Resolved')); TYPE del_tab_typ IS TABLE OF c1%ROWTYPE; del_tab del_tab_typ; BEGIN OPEN c1; LOOP FETCH c1 BULK COLLECT INTO del_tab LIMIT 100; EXIT WHEN del_tab.COUNT = 0; FORALL i IN del_tab.FIRST .. del_tab.LAST EXECUTE IMMEDIATE del_tab(i).delete_stmt; DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT); END LOOP;END;ORA-06550: line 29, column 13:PLS-00801: internal error [*** ASSERT at file pdw4.c, line 3579; Can't handle Object = -2147483537 in D_S_ED -2147483580.; Xanon__0x121b2da60__AB[29, 13]]If I am trying to hard code the table name and column name, it's working. I have written this kind of NDS before but all of them worked. This time, the database is new to me and version is 11.0.2.3. Is there any configuration I am missing! Please advise. I have the same question Show 0 Likes(0) 1611Views Tags: none (add) forallContent tagged with forall, plsqlContent tagged with plsql This content has b
v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production scott@10GR2> create type foo is object( x number); 2 / Type created. scott@10GR2> create type too is table of foo; 2 / Type created. scott@10GR2> declare 2 t1 too := new too(); 3 t2 too ; 4 begin 5 select foo(level) 6 bulk collect into t1 7 from dual 8 connect by level <= 5; 9 10 t2 := t1 multiset union https://community.oracle.com/thread/2558962 t2; 11 end; 12 / t2 := t1 multiset union t2; * ERROR at line 10: ORA-06550: line 10, column 2: PLS-00801: internal error [*** ASSERT at file pdw4.c, line 2076; Type 0x0AE3E5F4 has no MAP method.; _anon__2F37FA0C__AB[10, 2]] scott@11GR1> select * from v$version; BANNER -------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production PL/SQL Release 11.1.0.6.0 - Production CORE 11.1.0.6.0 Production TNS for 32-bit Windows: Version 11.1.0.6.0 - http://raajeshwaran.blogspot.com/2010/07/pls-00801-internal-error-assert-at-file.html Production NLSRTL Version 11.1.0.6.0 - Production scott@11GR1> create type foo is object( x number); 2 / Type created. scott@11GR1> create type too is table of foo; 2 / Type created. scott@11GR1> declare 2 t1 too := new too(); 3 t2 too ; 4 begin 5 select foo(level) 6 bulk collect into t1 7 from dual 8 connect by level <= 5; 9 10 t2 := t1 multiset union t2; 11 end; 12 / PL/SQL procedure successfully completed. As a workaround in Oracle 10g is to add a dummy MAP method to the object type foo. scott@10GR2> drop type too; Type dropped. scott@10GR2> drop type foo; Type dropped. scott@10GR2> create type foo is object( x number, 2 map member function mem return number); 3 / Type created. scott@10GR2> create type too is table of foo; 2 / Type created. scott@10GR2> declare 2 type t_arr is table of number; 3 data1 t_arr; 4 data2 t_arr; 5 begin 6 select level lvl 7 bulk collect into 8 data1 9 from dual 10 connect by level<=5; 11 12 data2 := data1 multiset union data2; 13 end; 14 / PL/SQL procedure successfully completed. Posted by RAJESH at 5:44 AM Email
error Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 8 ] 1 Topic by Lav 2012-05-06 10:14:59 Lav Member Offline Registered: 2002-02-05 Posts: 273 Topic: PLS-00801: http://www.progtown.com/topic561989-pls00801-internal-error.html internal error CREATE OR REPLACE PROCEDURE test AS TYPE tSqls IS TABLE OF VARCHAR2 (4000) INDEX BY BINARY_INTEGER; l_m tSqls; BEGIN FORALL l_cnt IN INDICES OF l_m EXECUTE IMMEDIATE l_m (l_cnt); END; Compilation errors for PROCEDURE LAV.TEST Error: PLS-00801: internal error [*** ASSERT at file pdw4.c, line 589; Unknown expression Expr = 283.; TEST __ LAV __ P __ 75295 [5, 33]] Line: 5 Text: FORALL internal error l_cnt IN INDICES OF l_m EXECUTE IMMEDIATE l_m (l_cnt);What to do that, and in other place used forall... execute immediate also worked SELECT * FROM V$version BANNER Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod PL/SQL Release 10.2.0.3.0 - Production CORE 10.2.0.3.0 Production TNS for Linux: Version 10.2.0.3.0 - Production NLSRTL Version 10.2.0.3.0 - Production 2 Reply by Lav 2012-05-06 10:32:59 Lav Member Offline Registered: 2002-02-05 00801 internal error Posts: 273 Re: PLS-00801: internal error The people, well you though tell at you as or not?--All that all does not become to the best... 3 Reply by Lav 2012-05-06 10:34:00 Lav Member Offline Registered: 2002-02-05 Posts: 273 Re: PLS-00801: internal error CREATE OR REPLACE PROCEDURE test AS TYPE tSqls IS TABLE OF VARCHAR2 (4000) INDEX BY BINARY_INTEGER; TYPE tr IS RECORD ( lSQL VARCHAR2 (1000); els tSqls); TYPE TSqlMain IS TABLE OF tr INDEX BY BINARY_INTEGER; l_m TSqlMain; BEGIN FORALL l_cnt IN INDICES OF l_m (1).els SAVE EXCEPTIONS EXECUTE IMMEDIATE l_m (1).lSQL USING l_m (1).els (l_cnt) ; END; COMPILED SUCESSFULLY 4 Reply by Elic 2012-05-06 10:40:00 Elic Member Offline Registered: 2012-05-02 Posts: 25,219 Re: PLS-00801: internal error Lav wrote: FORALL... EXECUTE IMMEDIATE l_m (l_cnt); Smoke to dock:[quote =] dynamic (EXECUTE IMMEDIATE) DML statement that references collection elements in the VALUES or WHERE clauses . also experience a difference between-nadtsatju parse and-nadtsatju execute 5 Reply by Lav 2012-05-06 10:41:00 Lav Member Offline Registered: 2002-02-05 Posts: 273 Re: PLS-00801: internal error a trial and error method it is possible to receive an axiom: For Forall... execute immediate l_sql using l_params l_sql - THERE SHOULD BE A CONSTANTl_params - Can ch