RE: continue oracle 11g verses 10g
- From: "Patterson, Joel" <Joel.Patterson@xxxxxxxxxxx>
- To: "Patterson, Joel" <Joel.Patterson@xxxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>, Jared Still <jkstill@xxxxxxxxx>, "tim@xxxxxxxxx" <tim@xxxxxxxxx>
- Date: Fri, 28 Dec 2012 07:49:19 -0500
P.S. I'm going to put the whole thing in a package with this idea -- and put
some other things in it as well.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: Patterson, Joel
Sent: Friday, December 28, 2012 7:46 AM
To: Patterson, Joel; oracle-l; Jared Still; tim@xxxxxxxxx
Subject: RE: continue oracle 11g verses 10g
Jared,
[Pasted your response in original posting here.]
Yes, I looked at
http://www.oracle.com/technetwork/database/features/plsql/overview/plsql-conditional-compilation-133587.pdf
However, I'm not 'getting it' fast enough. (I like working examples I can
follow from the beginning). If you have something more or better on the
Conditional Compilation, send it along.
However I thought last night, that what I could do is take the conditions that
are deciding whether to continue or not, and put them into a function. Then
ignore one of the options. In this particular case I believe the GOTO can be
eliminated -- as well as the CONTINUE infact. :) The things you think of when
you're not working the problem.
It would look Something like this -- the function will return True or False.
If LOOPDONE then
Print something.
END IF
--- here the loop would continue with next iteration.
Thanks,
....
On Thu, Dec 27, 2012 at 11:08 AM, Patterson, Joel <Joel.Patterson@xxxxxxxxxxx>
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
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Patterson, Joel
Sent: Thursday, December 27, 2012 2:08 PM
To: oracle-l
Subject: continue oracle 11g verses 10g
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).
I want the for loop to continue iterating regardless of the version. I
started looking at PL/SQL conditional compilations Oracle 2005,
http://www.oracle.com/technetwork/database/features/plsql/overview/plsql-conditional-compilation-133587.pdf
but looks like it is either not right or too complicated for this. Execute
immediate also does not appear to work inside the function for this task.
What to the listers recomend?
For I ...
<<message loop>>
... do stuff...
if v_oracle11g then
-- execute immediate 'continue';
continue;
else
-- execute immediate 'goto message_loop';
goto message_loop;
end if;
end loop;
Joel Patterson
Database Administrator
904 727-2546
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
