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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Compilerdirektiven for backward compatibility

Re: Compilerdirektiven for backward compatibility

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 27 Jan 2007 09:49:35 -0800
Message-ID: <1169920173.110639@bubbleator.drizzle.com>


Nicolas Bronke wrote:
> I search for a solution with backward compatbility. That means, I have
> to enhance a procedure in a package. My changes works fine with Oracle
> 9i and 10g but not with 8.1.7
>
> Here an example
>
> update TABLENAME B
> set
> LIMIT=(select LIMIT from TABLENAME A

One consideration should be that LIMIT is a reserved word from 9i onward.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jan 27 2007 - 11:49:35 CST

Original text of this message

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