Package scriptella.driver.oracle

Oracle Driver Adapter for Scriptella.

See: Description

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>

Copyright © Copyright 2006-2012 The Scriptella Project Team.