Skip to content

Instantly share code, notes, and snippets.

@mayribeirofernandes

mayribeirofernandes/oracle_connection_databaseLibrary.robot

Created June 25, 2021 18:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mayribeirofernandes/09e03b56fb8518f48197a1782cfb7bc2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mayribeirofernandes/09e03b56fb8518f48197a1782cfb7bc2 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle com DatabaseLibrary do Robot Framework
Raw
oracle_connection_databaseLibrary.robot
# Usando a DatabaseLibrary, instale o driver cx_Oracle (pip install cx-Oracle) e conecte assim:
Teste DatabaseLibrary
Connect To Database Using Custom Params cx_Oracle '${DB_USER}/${DB_PWD}@${DB_HOST}:${DB_PORT}/${DB_SID}'
# Só lembrando que para pegar o ${DB_SID}, pode estar escrito "SID" ou "service_name" lá no tnsnames.ora
# Provavelmente vai dar algum erro de oracle client, se der, você terá que baixar esse client e mapear nas variáveis de ambiente do seu S.O.
# No Windows é https://download.oracle.com/otn_software/nt/instantclient/19900/instantclient-basic-windows.x64-19.9.0.0.0dbru.zip, baixa,
# descompacta, joga numa pasta e mapeia essa pasta como variável de ambiente
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment