pl/sql table problem

From: grace lim <mglim_at_softhome.net>
Date: Tue, 11 Jul 2000 14:50:01 +0800
Message-Id: <10554.111630@fatcity.com>

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 Received on Tue Jul 11 2000 - 01:50:01 CDT