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:

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>