Prerequisites

To get the most out of this guide, you will need to:

Configuration

NameRequiredDescription
SQLCL_URIyesThe connect identifier. Example: myusername/mypassword@Host/ORCL
TERMyesThe name of terminal setting

In order to configure this type, it’s necessary to create the target directly from the API

hoop admin create conn my-oracle-db -a <agent> \
	-e SQLCL_URI=<uri> \
	-e TERM=<term> \
	-- sqlcl

Examples

Then, it’s possible to run queries into an Oracle database

hoop exec my-oracle-db -i 'SELECT SYSDATE, CURRENT_TIMESTAMP FROM DUAL'