Re: pl/sql table no data found

PL/SQL tables may contains index "holes" (they not plain as native db tables). Row number 65 may be absent in your PL/SQL table. If you drive to such table hole you got "no data found" exception. Try to close inspect your PL/SQL table load code, load data, process logic.

May be this helps.

pmitchel_at_kcc.com wrote:

> 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 Fri Feb 19 1999 - 21:13:00 CET