Skip to content

Instantly share code, notes, and snippets.

@Rizwan-Hasan
Last active October 7, 2019 12:05
Show Gist options
  • Save Rizwan-Hasan/9e6fa4ea3a91caefbff491f55d3559e0 to your computer and use it in GitHub Desktop.
Save Rizwan-Hasan/9e6fa4ea3a91caefbff491f55d3559e0 to your computer and use it in GitHub Desktop.
import cx_Oracle
def main():
# Variables
username: str = "HR"
password: str = "<YOUR_PASSWORD>"
host: str = "localhost"
service: str = "XE"
# Connection establishing
connection = None
try:
connection = cx_Oracle.connect(
username,
password,
"{0}/{1}".format(host, service)
)
print("Connection successful")
connection.close()
except cx_Oracle.DatabaseError as e:
print(e)
if __name__ == '__main__':
main()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment