scriptella.driver.oracle.package.html Maven / Gradle / Ivy

Go to download


Oracle Driver Adapter for Scriptella.

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>

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