Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record ( field1 ae_dt526.field1%TYPE, action tab1_audit.action%TYPE, field13 tab1_audit.field13%TYPE, blanket_ind tab1_audit.blanket_ind%TYPE ); TYPE t_change_tab is table of t_change_rec; g_change_tab t_change_tab [...]

Answer Question   |  February 2, 2009  11:39 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers