Re: Declare multiple variables

From: T <t_at_yahoo.com>
Date: Tue, 22 Aug 2006 14:18:43 +0200
Message-ID: <ecesqm$q3g$1@ss408.t-com.hr>

<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
>

CREATE OR REPLACE procedure example as

--declare

l_first integer; l_second varchar2(10); begin null; end;

try without "declare", and with varchar2 try to specify format :) the rest will be just fine Received on Tue Aug 22 2006 - 07:18:43 CDT