Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in VARRAYs - Error # PLS-00316 and ORA-06531

122808Jan 2 2002
I am getting the following error in one sequence and other one
in another sequence.

ORA-06550: line 5, column 13: PLS-00316: PL/SQL TABLEs must
currently use a single binary_integer index.

The following is my code

create or replace type TKG as object (
xx1 varchar2(10),
xx2 varchar2(10)
) ;
/
create or replace type TKGVARRAY as varray(150) of TKG ;
/
create or replace type TKGTABLE is table of TKG ;
/

Calling program is
---------------------
1 declare
2 tkgarray TKGVARRAY ;

3 begin
4 tkgarray := tkgarray( TKG('xx1', 'xx3'), TKG('xx1', 'xx3'));

5 /*tkgarray.extend ;
6 tkgarray(1) := tkg('xx1', 'xx3') ;
7 tkgarray.extend ;
8 tkgarray(2) := tkg('xx2', 'xx4') ;
9 */
10 sddr_cir_stp_i(tkgarray) ;

11 commit ;

12 end ;

When I comment the line 4 and uncomment the line 5 to 9, then I
am getting the following error

ORA-06531: Reference to uninitialized collection.

Please somebody help me. The same code was working in my
previous project but not working in the current project.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 30 2002
Added on Jan 2 2002
2 comments
2,222 views