Re: Declare multiple variables

<devjnr_at_gmail.com> wrote in message
news:1156242895.974550.283860_at_h48g2000cwc.googlegroups.com...
> Is it possible to do this?
>
> declare l_first integer; l_second varchar2;
>
> begin
>
> ...
>
> end
>
>
> raise an error...with Ora10g R2
>
> Thx for help
>

You need to define the length of your varchar2 field. This works fine:

declare l_first integer; l_second varchar2(10);

begin

null;

end; Received on Tue Aug 22 2006 - 06:24:25 CDT