Oracle Magazine, May/June 2019
ORACLE MAGAZINE MAY JUNE 2019 68 Database Developer OPEN SOURCE 2 Set the TNS_ ADMIN environment variable to point to the directory from which you extracted the client credentials files 3 Create a database connection with the username password and service used in the above tests 4 Use the connection as you would any other Oracle Database connection in your application LANGUAGE SPECIFIC EXAMPLES For the following examples I have defined environment variables for TNS_ ADMIN and the user password service and connect string export TNS_ ADMIN home demouser projects ATP Wallet_ Creds export OADB_ USER demo export OADB_ PW demoPassword export OADB_ SERVICE BlaineATP_ MEDIUM export OADB_ CONNECTSTRING OADB_ USER OADB_ PW@ OADB_ SERVICE Python To connect to the Oracle Autonomous Transaction Processing database instance with Python do the following 1 Download and install the cx_ Oracle driver 2 Create the python_ demo py file with the following code import cx_ Oracle import os con cx_ Oracle connect os environ OADB_ USER os environ OADB_ PW
You must have JavaScript enabled to view digital editions.