Oracle Actions

Oracle actions are used to interact with tables on Oracle Server.

Actions

oracle.open

Open a new connection with database

Parameters:

host - IP or hostname of the server to connect

user - username to be used on Oracle authentication

url - Oracle URL

password - Password to be used on Oracle authentication

sid (optional) - Oracle site identifier (default=None)

service (optional) - Net service names used for application connection strings to your database

port (optional) - Number of the port to connect with Oracle Server (default=1521)

oracle_client_path (optional) - Path to your Oracle, if your installation is not in the default path

Return:

This action has no return

Exceptions:

ConnectionException - When problems with Oracle Server connection occurs.

oracle.close

Closes connection with database

Parameters:

connection - Oracle instance given from oracle.open

Return:

This action has no return

Exceptions:

This action returns no Exception

oracle.commit

Commit all transactions of the given connection

Parameters:

connection - Oracle instance given from oracle.open

Return:

This action has no return

Exceptions:

This action returns no Exception

oracle.execute_sql

Execute a SQL command in Oracle Server

Parameters:

connection - Oracle instance given from oracle.open

sql - String with SQL command to be executed

auto_commit (optional) - Set if the auto commit on transaction should be used or not (default=True)

Return:

result - Grid with all results returned for SQL command

count - Number of lines returned by result

affected_rows - Number of lines affected by SQL command execution

Exceptions:

ConnectionException - When problems with Oracle Server connection occurs

oracle.rollback

Rollback the transation in Oracle Server

Parameters:

connection - Oracle instance given from oracle.open

Return:

This action has no return

Exceptions:

This action returns no Exception

oracle.select

Execute a SQL query in Oracle Server

Parameters:

connection - Oracle instance given from oracle.open

sql - String with SQL command to be executed

Return:

result - Grid with all results returned for SQL command

count - Number of lines returned by result

Exceptions:

ConnectionException - When problems with Oracle Server connection occurs