Help PL/SQL (Table Datatype.)

From: Sylvain <sylb_at_microtec.net>
Date: Wed, 2 Sep 1998 14:07:58 -0400
Message-ID: <6sk1lr$tq$1_at_news.quebectel.com>

Hello,

Here's what i'm trying to do. I use pl/sql table datatype and would like to be able to delete these tables after i'm finish with them.

I'm trying some pl/sql code from the oracle book that doesn't work for me ?

Every time i assign null to my table to delete them i get an error like "Expression is wrong type..."

Is there any other way to do this ?

---

--

Oracle Version :

Oracle7 Server Release 7.1.6.2.0 - Production Release PL/SQL Release 2.1.6.2.0 - Production

---

--

Example from the book :

DECLARE
   TYPE NumTabTyp IS TABLE OF NUMBER

      INDEX BY BINARY_INTEGER;
   sal_tab NumTabTyp;
BEGIN
   /* Load salary table. */
   FOR i IN 1..50 LOOP

      sal_tab(i) := i;
   END LOOP;
   ...
   sal_tab := NULL; -- deletes sal_tab table <---- this line does'nt work for me ??? Received on Wed Sep 02 1998 - 20:07:58 CEST