Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HELP PL/SQL (TABLE DATATYPE)
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 ?
Oracle7 Server Release 7.1.6.2.0 - Production Release PL/SQL Release 2.1.6.2.0 - Production
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 - 13:10:30 CDT