RE: pl/sql table problem

Hello Grace,

Tried the same using a simple PL/SQL block. It doesn't delete the whole PL/SQL table (just deletes the individual element).

But since this is a nested table, the data will not move up. The data remains in the original position and if you try to reference a deleted element, you get the 'no_data_found' error.

Hope this helps!

Prakash

> -----Original Message-----
> From: grace lim [SMTP:mglim_at_softhome.net]
> Sent: Tuesday, July 11, 2000 4:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: pl/sql table problem
>
> gurus,
>
> i made a package called pckg_tbl w/ the ff :specifcation.
>
> PACKAGE pckg_tbl IS
> type gen_table is table of varchar2(100) not null
> index by binary_integer;
> tmp_tbl gen_table;
>
> function is_duplicate(item in varchar2,pos in number) return boolean;
> END;
>
> when the stmt pckg_tbl.tmp_tbl.delete(1) is issued in any part of the
> form... it deletes all the data from the table
> it supposed to delete only the row of the specified index . and the rest
> data will move up.
>
>
> eg. if pckg_tbl.tmp_tbl.delete(1) is issued
>
> table a => result shld be table a
> ----------
> -----------
> a
> b
> b
> c
> c
>
>
> eg. if pckg_tbl.tmp_tbl.delete(2) is issued
>
> table a => result shld be table a
> ----------
> -----------
> a
> a
> b
> c
> c
>
> Grace Lim
> Suy Sing Comm'l Corp.
> 247-41-34
> --
> Author: grace lim
> INET: mglim_at_softhome.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jul 11 2000 - 13:59:49 CDT