Re: <table>.Delete do not work why ?

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/03
Message-ID: <3393f5fd.7739180@www.sigov.si>#1/1

On Tue, 27 May 1997 10:51:23 GMT, jurij.modic_at_mf.sigov.mail.si (Jurij Modic) wrote:

>On 27 May 1997 08:38:04 GMT, "Bors" <bors_at_park.ru> wrote:
>
>>My best regards to all!
>>Please help in some problem:
>>I have folowing declaration in PL/SQL
>>
>>DECLARE
>> TYPE num_array IS TABLE OF ....
>>
>> numList num_array;
>>BEGIN
>>....
>> numList.DELETE;
>>
>> PLS-00201: identifier 'NUMLIST.DELETE' must be declared
>>
>>Why ?
>
>AFAIK ther is no way to delete a row from PL/SQL table type.
>
>You can only set particular row to NULL, but the row still exists. You
>can delete all rows from table by assigning an empty table of the same
>type to it.

Sorry, I have switched to version 7.3 only recently and I have yust found out that what I had written above is not correct any more.

What I have written in previous message was true for PL/SQL releases 2.1 and 2.2, but in 2.3 the things regarding PL/SQL tables have changed significantly. So, you were right, your sintax should work in PL/SQL ver. 2.3.

Possible answers why your construct does not work might be: a) PL/SQL engine release prior to 2.3
b) Your database init parameter COMPATIBLE is set to release prior to 7.3

Regards,

Jurij Modic                             Republic of Slovenia
tel: +386 61 178 55 14                  Ministry of Finance
fax: +386 61  21 45 84                  Zupanciceva 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

Received on Tue Jun 03 1997 - 00:00:00 CDT