Package scriptella.driver.oracle

Oracle Driver Adapter for Scriptella.

See: Description

Class Summary

Class	Description
Driver	Scriptella Adapter for Oracle database.
OracleConnection	Oracle connection wrapper.

Package scriptella.driver.oracle Description

Oracle Driver Adapter for Scriptella.

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

General information

Driver class:	scriptella.driver.oracle.Driver
URL:	Same as for Oracle JDBC Driver.
Runtime dependencies:	ojdbc14.jar

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>