ORA-06532: Subscript outside of limit [message #427769] |
Sun, 25 October 2009 05:10 |
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 #427776 is a reply to message #427769] |
Sun, 25 October 2009 06:38 |
flyboy
Messages: 1903 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).
|
|
|
|