How to connect to a Oracle Cloud Native Database using Python

Question

I am trying to connect to Oracle CNDBaaS using python and execute some queries. I am using the Cx_Oracle module.Here's the code. I am taking input from config.properties file.

   source_username =  config.get("Source Details", "USERNAME")

   source_password = config.get("Source Details", "PASSWORD")

   source_dsn =  config.get("Source Details", "DSN")

   source_port =  config.get("Source Details", "PORT")

   encoding = config.get("Source Details", "ENCODING")


   connection = None

   try:
        connection = cx_Oracle.connect (
        
            source_username,
    
            source_password,
    
            source_dsn,encoding=encoding 
    
            )
     
       cursor = connection.cursor()
    
       print("Source Connection is successful")
    
     
  except Exception as e: 

    print(e)

This code works fine for all oracle databases except cloud one. Can somebody please help

Answer 1

等待大神答复