SQL Language (MOSC)

MOSC Banner

ORA-00976: Specified pseudocolumn or operator not allowed here - Why? 11.2.0.2

edited Nov 27, 2011 7:25PM in SQL Language (MOSC) 1 commentAnswered ✓
FOR r_get_invoice_data IN c_get_invoice_data(a_in_month) LOOP

      n_row:=n_row+1;

      INSERT INTO ldx_snapshot_res_rows

                  (snapshot_id,

                   data1,

                   data2,

                   data3,

                   data4,

                   data5,

                   data6,

                   seq_no

                  )

           VALUES (n_in_snapshot_id,

                   r_get_invoice_data.invoice_date,

                   r_get_invoice_data.invoice_no,

                   r_get_invoice_data.style,

                   r_get_invoice_data.value_for_duty_tot,

                   r_get_invoice_data.vat_10,

                   r_get_invoice_data.vat_18,

                   ROWNUM

                  );

    END LOOP;


Is this behaviour new in 11.2.0.2? We have just moved from 10.2.0.4 to 11.2.0.2

Regards

U

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center