Re: continue oracle 11g verses 10g
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 27 Dec 2012 13:18:58 -0800
Message-ID: <CAORjz=OCDOyX8TsU-RYSsUXmjbC=csDr_UMbgg0hp2gQVvGx8w_at_mail.gmail.com>
On Thu, Dec 27, 2012 at 11:08 AM, Patterson, Joel < Joel.Patterson_at_crowley.com> wrote:
> I have a function (Solaris 5.10, all versions of oracle), that I wish the
> same code to compile and run on oracle versions 9, 10, and 11. (you can
> dismiss 9 however).
>
> CONTINUE was introduced in 11g. Before 11g, there were various work
> arounds, but in my case I'll use the goto <<label>> method (ie 10g).
>
Date: Thu, 27 Dec 2012 13:18:58 -0800
Message-ID: <CAORjz=OCDOyX8TsU-RYSsUXmjbC=csDr_UMbgg0hp2gQVvGx8w_at_mail.gmail.com>
On Thu, Dec 27, 2012 at 11:08 AM, Patterson, Joel < Joel.Patterson_at_crowley.com> wrote:
> I have a function (Solaris 5.10, all versions of oracle), that I wish the
> same code to compile and run on oracle versions 9, 10, and 11. (you can
> dismiss 9 however).
>
> CONTINUE was introduced in 11g. Before 11g, there were various work
> arounds, but in my case I'll use the goto <<label>> method (ie 10g).
>
Joel, have you considered conditional compilation?
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 27 2012 - 22:18:58 CET