PL/SQL (MOSC)

MOSC Banner

Assignment to varray element fail inexplicably

edited Sep 7, 2011 9:00AM in PL/SQL (MOSC) 13 commentsAnswered
Hi,

I have PL/SQL script containing the following sequence of commands:

....

node_seqX.DELETE;
i:=cntX.FIRST;
node_seqX.EXTEND;
node_seqX(1):=i;

....

The definitions of the collections are as follows:

TYPE node_seqT IS VARRAY(300) OF NUMBER;

TYPE cnt_typeT IS TABLE OF NUMBER
  INDEX BY PLS_INTEGER;

cntX cnt_typeT;

node_seqX node_seqT:=node_seqT();

The script ran many times without problems, but now the last statement causes the script to hang.

The value of cntX.FIRST is 480620, if I put this value in the last statement instead of i, it runs without problems.

I cannot make out what the cause could be.

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