Re: Declare multiple variables

From: T <t_at_yahoo.com>
Date: Tue, 22 Aug 2006 14:22:37 +0200
Message-ID: <ecet21$qom$1@ss408.t-com.hr>

"T" <t_at_yahoo.com> wrote in message news:ecesqm$q3g$1_at_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
>

sorry, this works with stored procedures, otherwise declare is obligate!!! Received on Tue Aug 22 2006 - 07:22:37 CDT