Autonomous Database and Conditional Compilation
From: Ethan Post <post.ethan_at_gmail.com>
Date: Fri, 22 Nov 2019 09:28:56 -0600
Message-ID: <CAMNhnU0RNigxCzxbJGD1PecwOjyR4m1Xk1HmHObFh9V0AVA28A_at_mail.gmail.com>
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.
Date: Fri, 22 Nov 2019 09:28:56 -0600
Message-ID: <CAMNhnU0RNigxCzxbJGD1PecwOjyR4m1Xk1HmHObFh9V0AVA28A_at_mail.gmail.com>
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-lReceived on Fri Nov 22 2019 - 16:28:56 CET