FORALL bulk bind error question

From: <mcconje_at_my-deja.com>
Date: Mon, 17 Apr 2000 14:51:35 GMT
Message-ID: <8df8df$or7$1_at_nnrp1.deja.com>



Hello,
[Quoted] We are currently running 8.1.5.0.0 and I am attempting to compile this code.

In package LFI_TB_CONTROL spec

TYPE AP_INV_TABLE_TYPE IS TABLE OF APCINVOICE%ROWTYPE         INDEX BY BINARY_INTEGER; AP_INV_TB AP_INV_TABLE_TYPE;


In package LFI_LOAD body

FORALL X IN

LFI_TB_CONTROL.AP_INV_TB.FIRST..LFI_TB_CONTROL.AP_INV_TB.LAST
         INSERT INTO DEV_OWNER.LFI_APCINVOICE
         VALUES(LFI_TB_CONTROL.AP_INV_TB(X).COMPANY);

and I am getting PLS-00707 unsupported construct or internal error [2603]

Was windering if anyone else has had this problem and if so how did you correct it?

Thanks All
Jeff McConnell

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Apr 17 2000 - 16:51:35 CEST

Original text of this message