Package scriptella.driver.oracle

package scriptella.driver.oracle
Oracle JDBC adapter for Scriptella.

See Overview of JDBC package for a description of common features and connection properties.

See the core database compatibility matrix for the current validation target and status.

General information

Driver class:scriptella.driver.oracle.Driver
JDBC driver class:oracle.jdbc.OracleDriver
URL:jdbc:oracle:thin:@host:1521/service
Runtime dependencies: Oracle JDBC driver (ojdbc17.jar for JDK 17 and later), supplied through the connection classpath.

Driver Specific Properties

Name Description Required
plsql If true the slash on a single line is used as a separator for SQL statements. This mode is required to create triggers and execute blocks of PL/SQL code. No, the default value is false

Examples

    <connection id="c1" driver="oracle" url="jdbc:oracle:thin:@localhost:1521:DB" user="sys as sysdba" password="password">
    </connection>

    <connection id="c2" driver="oracle" url="jdbc:oracle:oci:@localhost:1521:DB" user="scott" password="tiger">
        plsql=true;
    </connection>

    <script connection-id="c2"/>
        CREATE OR REPLACE PACKAGE PK_TEST_PACKAGE1 AS
            PROCEDURE PP_TEST_PROCEDURE1( param   IN  VARCHAR2);
        END PK_TEST_PACKAGE1;
        /
        CREATE OR REPLACE PACKAGE PK_TEST_PACKAGE2 AS
            PROCEDURE PP_TEST_PROCEDURE2( param   IN  VARCHAR2);
        END PK_TEST_PACKAGE2;
        /
    </script>
  • Classes
    Class
    Description
    Driver
    Scriptella Adapter for Oracle database.
    OracleConnection
    Oracle connection wrapper.