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

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.

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