How to work with PL/SQL and the Oracle DBMS

We recommend using our PL/SQLJob job for working with SQL and Oracle™ RDBMS.
This is one of our JITL Jobs by Topic: Database jobs that are delivered with JobScheduler.

Use JOE to create a PL/SQL job:

• Open JOE's Job Wizard
• Select JobSchedulerPLSQLJob in the list of available jobs and enter a job name
• Goto "next" to set some parameters for the database connection etc.
• See the reference documentation for the PL/SQLJob job to get more information about the job parameters
• After you have finished the wizard then you can insert the PL/SQL script in the script tab of the job.
• Alternatively you can put the PL/SQL script in an external file and enter this filename in the parameter "command".

You get a job like the following:

<?xml version="1.0" encoding="ISO-8859-1"?>


<job  title="Execute PL/SQL procedure" order="no">
    <description >
        <include  file="jobs/JobSchedulerPLSQLJob.xml"/>
    </description>

    <params >
        <param  name="db_url" value="jdbc:oracle:thin:@localhost:1521:test"/>

        <param  name="db_user" value="test"/>

        <param  name="db_password" value="test"/>
    </params>

    <script  language="java" java_class_path="" java_class="sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass">
        <![CDATA[
begin
      dbms_output.put_line('hello world');
end;
        ]]>
    </script>

    <run_time />
</job>