Re: Declare multiple variables

From: Acme Acmeson <nahdsl232734_at_nahvip.cybercity.dk>
Date: Tue, 22 Aug 2006 14:01:05 +0200
Message-ID: <44eaf1f6$0$145$157c6196@dreader1.cybercity.dk>

"Acme Acmeson" <nahdsl232734_at_nahvip.cybercity.dk> wrote in message news:44eae95f$0$143$157c6196_at_dreader1.cybercity.dk...
>
> <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;

and so does this:
declare l_first integer; l_second varchar2(30);begin l_second := 'devjnr_at_gmail.com'; end;

really, you should have testet that out before posting ! Received on Tue Aug 22 2006 - 07:01:05 CDT