Re: FORALL bulk bind error question

In article <8df8df$or7$1_at_nnrp1.deja.com>,   mcconje_at_my-deja.com wrote:
> Hello,
> 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?

you must use tables of scalars with the BULK collection features. It does not work with tables of records.

>
> Thanks All
> Jeff McConnell
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.