Re: DELETE ident_arr PL/SQL table

A copy of this was sent to macflores_at_northwestern.edu (Mac Flores IV) (if that email address didn't require changing) On 18 May 2001 16:27:55 GMT, you wrote:

>I'm getting an error when I try to delete an entry from a
>PL/SQL table:
>
>"PLS-00363: expression 'FT_CORRECT' cannot be used as an
> assignment target"
>

it is an IN parameter, you cannot modify an IN parameter.

procedure my_procedure( p_ft_correct in owa_util.ident_arr ) is
  ft_correct owa_util.ident_arr := p_ft_correct; begin

   .....

will work

>The relevant code is as follows:
>
>PROCEDURE my_procedure( ft_correct IN owa_util.ident_arr )
>IS
>BEGIN
> .
> .
> .
> ft_correct.DELETE( ft_correct.LAST );
> .
> .
>END;
>
>What seems to be wrong in this snippet . . .? Any
>suggestions/help/solutions greatly appreciated.

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp