pl/sql table no data found

From: <pmitchel_at_kcc.com>
Date: Thu, 18 Feb 1999 17:05:45 GMT
Message-ID: <7ahh92$jrd$1_at_nnrp1.dejanews.com>

[Quoted] Hi, I have a pl/sql table (temporary table) that is defined as a global

variable in a package.	Many of the functions in the package reference this
table.	The bizarre thing is that it works for a 'while', i.e. 10 iterations,

but then it abends on record #64, no data found. To debug and identify what's going on, we've done the following:

Globals:
TYPE tt_cald_type IS TABLE OF DATE NOT NULL INDEX BY BINARY_INTEGER; g_locsrc_cald_tbl tt_cald_type;
g_empty_locsrc_cald_tbl tt_cald_type;

The common function that builds this temporary table of date: 1. Sets the g_locsrc_cald_tbl to empty; (g_locsrc_cald_tbl := g_empty???_tbl; 2. Opens a cursor of dates to load in the table. 3. For each record in the cursor, insert a record into the g_loc_src_cald_tbl by binary_integer subscript. Also, for audit purposes only, load this same set of data to a working table (in our case, a 152 individual records are written to this working table). 4. Cursor is complete. Do a count on the table - g_locsrc_cald_tbl.count (in our case, 152 records are loaded). 5. As an audit, read thru the g_locsrc_cald_tbl and write all records to the work table again. It blows up on record #64.

Now, this routine works at least 10 times successfully b/4 it abends. It always blows-up on record #64. The data is successfully loaded into the working table used for audit purposes.

So, any ideas? 1. Is it because it's defined as a global variable to this package? Is there a memory issue? We're talking about a small set of records, i.e. 150 to 160. 2. Any other ideas?

Appreciate any help... thanks Pat...............

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 18 1999 - 18:05:45 CET