Re: Autonomous Database and Conditional Compilation

From: kris rice <kris.rice_at_jokr.net>
Date: Sat, 23 Nov 2019 07:40:03 -0500
Message-ID: <CAPVZWiPGnfV+0dV9QYrRXAkQsuipkGvC3KaayBmwDLgKLp4nug_at_mail.gmail.com>



Here you go...

https://twitter.com/krisrice/status/1198219314412838912?s=20

SQL Example here: https://t.co/PQYY3CHtUF?amp=1

-kris

On Fri, Nov 22, 2019 at 10:29 AM Ethan Post <post.ethan_at_gmail.com> wrote:

> Anyone know of a constant (or way) I can access to determine if I am
> trying to compile into an autonomous database? I would like to set up some
> conditionals in my code.
>
> Most of the examples use DBMS_DB_VERSION but don't see anything in the
> docs for this but might not be looking in the right place.
>
> Alternative path at the moment (untested) is to query for the cloud user
> accounts and if found try to set a CCFLAG and check for that but ideally I
> want to just compile the package and not have to run SQL prior to that.
>
> Thanks,
> Ethan
> https://e-t-h-a-n.com
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Nov 23 2019 - 13:40:03 CET

Original text of this message