Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Declare multiple variables

Re: Declare multiple variables

From: sybrandb <sybrandb_at_gmail.com>
Date: 22 Aug 2006 03:37:47 -0700
Message-ID: <1156243067.261099.278160@m73g2000cwd.googlegroups.com> 






dev..._at_gmail.com wrote:


> Is it possible to do this?

>

> declare l_first integer; l_second varchar2;

>

> begin

>

> ...

>

> end

>

>

> raise an error...with Ora10g R2

>

> Thx for help




One variable per line, as per the PL/SQL reference manual.
Please refer to this manual prior to posting.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Tue Aug 22 2006 - 05:37:47 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US