Home » SQL & PL/SQL » SQL & PL/SQL » ORA-06532: Subscript outside of limit (10g)
ORA-06532: Subscript outside of limit [message #427769] Sun, 25 October 2009 05:10 Go to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
In this code
ELSIF p_table_type = 3 THEN
 FOR RSI IN (SELECT * FROM TABLE(CAST(rsi_list AS xx_number_list)))
 LOOP
--  IF RSI.column_value <> 12345678 THEN
dbms_output.put_line(RSI.column_value);
   xx_reports_api.open_data_line;
   xx_reports_api.add_tab_cell (p_data=>RSI.column_value,p_colspan => '9',p_type => 'TH');
   xx_reports_api.close_data_line;
    FOR i IN nvl(v_get_table.first,1)..nvl(v_get_table.last,0) LOOP
     IF INSTR(','||v_get_table(i).rsi||',',','||RSI.column_value||',') > 0 THEN
     xx_reports_api.add_tab_cell (v_get_table(i).rsi,                    '100');
     xx_reports_api.add_tab_cell (v_get_table(i).SYS,                    '50');
     xx_reports_api.add_tab_cell (v_get_table(i).package_id||'#'||v_get_table(i).package_seq,      '50');
     xx_reports_api.add_tab_cell (v_get_table(i).developer				 , '150');
     xx_reports_api.add_tab_cell (v_get_table(i).object_type,             '100');
     xx_reports_api.add_tab_cell (v_get_table(i).object_name,             '200');
     xx_reports_api.add_tab_cell (v_get_table(i).object_location,         '200');
     xx_reports_api.add_tab_cell (v_get_table(i).deployment_time,         '200');
     xx_reports_api.add_tab_cell ('yet to be added'             ,     '100');     
     END IF;
    END LOOP;
--  END IF; 
 END LOOP;

I am getting this error any clues!!
1684
1704
1871
1920
2027
2096
2117
12345678
BEGIN
*
ERROR at line 1:
ORA-06532: Subscript outside of limit
ORA-06512: at "XXMITG.XX_REPORTS_API", line 133
ORA-06512: at "XXMITG.XX_REPORTS_API", line 500
ORA-06512: at "XXMITG.DEPLOYMENT_TIMECOUNT", line 243
ORA-06512: at "XXMITG.DEPLOYMENT_TIMECOUNT", line 263
ORA-06512: at line 2

[Updated on: Sun, 25 October 2009 05:11]

Report message to a moderator

Re: ORA-06532: Subscript outside of limit [message #427772 is a reply to message #427769] Sun, 25 October 2009 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-06532: Subscript outside of limit
 *Cause:  A subscript was greater than the limit of a varray
          or non-positive for a varray or nested table.
 *Action: Check the program logic and increase the varray limit
          if necessary.

Regards
Michel
Re: ORA-06532: Subscript outside of limit [message #427776 is a reply to message #427769] Sun, 25 October 2009 06:38 Go to previous messageGo to next message
flyboy
Messages: 1831
Registered: November 2006
Senior Member
In addition:
ORA-06512: at "XXMITG.XX_REPORTS_API", line 133
ORA-06512: at "XXMITG.XX_REPORTS_API", line 500
ORA-06512: at "XXMITG.DEPLOYMENT_TIMECOUNT", line 243
ORA-06512: at "XXMITG.DEPLOYMENT_TIMECOUNT", line 263
ORA-06512: at line 2

The exception raised from that lines on mentioned packages. As I am not aware of any standard Oracle packages starting with XX_, they are probably custom ones. Ask their vendor to fix them or use them properly (although it would be good if the package checked parameters for correctness in this case).
Re: ORA-06532: Subscript outside of limit [message #427800 is a reply to message #427776] Sun, 25 October 2009 12:47 Go to previous message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
thanks all.

By increasing the varray limit solved the problem.
Previous Topic: How to get all the expensive/costly query
Next Topic: Self Join to fetch required data
Goto Forum:
  


Current Time: Thu Sep 29 00:33:25 CDT 2016

Total time taken to generate the page: 0.09038 seconds