Filters

Search Results ()

Search Results ()

    All Plugins (147)

    Quick Info

    Product
    HCL Launch
    Type
    plugin
    Compatibility
    HCL Launch version 7.0 or later
    Created by
    HCL Software
    Website
    Published Date
    March 11th, 2021
    Last Updated
    April 14th, 2022

    Description

    SQL*Plus is an Oracle database client that run SQL and PL/SQL commands and display their results. SQL*Plus is the default and the most basic Oracle utility, with a basic command-line interface. The SQLPlus plugin allows HCL Launch to run SQL scripts during deployment.

    Quick Info

    Product
    HCL Launch
    Type
    plugin
    Compatibility
    HCL Launch version 7.0 or later
    Created by
    HCL Software
    Website
    Published Date
    March 11th, 2021
    Last Updated
    April 14th, 2022

    launch-sqlplus-22.1126471.zip

    Uploaded: 08-Dec-2021 09:49

    launch-sqlplus-21.1124890.zip

    Uploaded: 10-Nov-2021 08:33

    launch-sqlplus-21.1112579.zip

    Uploaded: 09-Jul-2021 12:25

    launch-sqlplus-20.1101989.zip

    Uploaded: 16-Mar-2021 06:11

    launch-sqlplus-20.1098503.zip

    Uploaded: 15-Mar-2021 14:09

    Summary

    The Oracle SQLPlus plugin automates the running of SQL scripts during deployment.

    This plugin includes one or more steps, click Steps for step details and properties.

    Compatibility

    The HCL Launch automation plugin for Oracle SQL*Plus works with Oracle 11 and later.

    This plugin requires HCL Launch version 7.0 or later.

    Installation

    See Installing plugins in HCL Launch for installing and removing plugins.

    History

    The following table describes the changes made in each plugin version.

    Plugin history details
    Version Description
    20 APAR PH19241: Avoid memory leaks by streaming file contents instead of storing them in memory.

    Usage

    Use the plugin steps to run a set of SQL statements with or without control files as part of the deployment process. Scripts are stored as an SQL file and are used to manage databases or to create the database schema during database deployment.

    If you use the SYS account to run SQL scripts, you must add the suffix as sysdba to the Connection ID field.

    Step palette

    To access this plugin in the palette, click Database > SQLPlus.

    Steps

    The following process steps are available in the Oracle SQL*Plus plugin.

    Run SQLPlus script

    Run SQLPlus script

    Input properties for the Run SQLPlus script step
    Name Type Description Required
    Connection ID String The connection ID to be used (example: localhost:1521/ORCL). If you use the SYS account to run SQL scripts, add the suffix AS SYSDBA. Yes
    Fail on Database Messages Boolean Check this box to fail on ORA- Database Messages. This option is ignored if the Skip SQL Errors option is selected. No
    Oracle Home String Optional field to specify the ORACLE_HOME environment variable value. This field is required to authenticate through Oracle Wallet. No
    Password Password The password of the user for the scripts to be run as. Leave this property blank and specify Oracle Home, if you wish to use Oracle Wallet authentication. No
    Password Script String If you want to use a script to provide password, specify the path to script leaving Password field blank. No
    SQL Files String A new-line or comma separated list of sql files to be executed. Order is preserved. Supports * and ? as wildcards. Yes
    SQL Files Args String A new-line or comma separated list of sql files Args to be executed, Use space to seperate args belonging to same file. Order is preserved. List the files having parameters first. Put the args in double quotes if it has space in it. No
    SQLPlus Executable String The full path to the sqlplus executable to be run or the command to run if it is on the path. Yes
    Skip SQL Errors Enumeration Ignore any PLS, SP2, and ORA errors encountered during script execution. Select True to skip error, or false to fail on errors. You can also select the parameterized value ${p?:skipSqlErrors}, which looks for the skipSqlErrors property in UCD. If the property isnt defined, the value is false. No
    User name String The user name for the scripts to be run as. Leave this property blank, and specify Oracle Home, if you wish to use Oracle Wallet authentication. No

    SQLPlus through Control File

    Run SQLPlus scripts using control files for orchestration.

    Input properties for the SQLPlus through Control File step
    Name Type Description Required
    ConnectionId x User to Password String A newline separated list of connection IDs, User Names and Passwords. The expected format for a line is username@connectionId=Password. To use Oracle Wallet authentication, use the format @connectionId. A combination of the two formats is allowed. Yes
    Control File Excludes String A newline seperated list of control file excludes for finding control files. Use * for matching any file or folder, and ** for recursively matching folders. No
    Control File Includes String A newline seperated list of control file includes for finding control files. Use * for matching any file or folder, and ** for recursively matching folders. Each line of a control file should be formatted thusly scriptName\tconnectionId\tuser\tABORT_FLAG. \t means whitespace tab. For an example of what a control file should look like, see control.example.txt and the readme.txt in the root of the plugin. No
    Mode Enumeration Whether to do a deployment or just check that the control files match the valid syntax and all sql files are found. Both modes perform an initial check. Values are check and deploy. No
    Oracle Home String Optional field to specify the ORACLE_HOME environment variable value. This field is required to authenticate through Oracle Wallet. No
    SQLPlus Executable String The full path to the sqlplus executable scripts to be run or the command to run if it is on the path. Yes