I am trying to test performance of making some SQL statements under a .py file, accessing my oracle.com Apex datasets.
The cx_Oracle package is installed and the client libraries as well.
I cannot set the connection string properly.
As user I pass my user login name as parameter?
As password is it expected to pass my user password on Oracle Apex portal?
And what about the rest of the string hostname/dbasename: what is exactly this hostname? As dbasename am I supposed to pass my workspace name as parameter?
Thank you for any help!