count the size of array variable

i hv created an array to store multiple data and passing it to sub program thru function.

in that sub program after some validation i hv to insert data from array to a table.now i need to find how many iteration do i need for that array.

Is there any function in oracle which can tell the total number of elements of an Array variable ?

yes
[ name of adt ].count

length

it returns the array size

Quote:

---

Originally Posted by crysu

length

it returns the array size

---

This is Oracle we're talking about?

Code:

---

Table 5-2 Collection Methods
Method        Type
Description

DELETE Procedure Deletes elements from collection.

TRIM Procedure Deletes elements from end of varray or nested table.

EXTEND Procedure Adds elements to end of varray or nested table.

EXISTS Function Returns TRUE if and only if specified element of varray or nested table exists.

FIRST Function
Returns first subscript in collection.

LAST Function
Returns last subscript in collection.

COUNT Function
Returns number of elements in collection.

LIMIT Function
Returns maximum number of elements that collection can have.

PRIOR Function
Returns subscript that precedes specified subscript.

NEXT Function
Returns subscript that succeeds specified subscript.

---