CODEWITHSUNDEEP
oracle-databasejdbcplsqlsqlplus
JARC
JARC

Reputation: 5328

Applying Oracle PL/SQL via JDBC

Is it possible to create/replace PL/SQL via the Oracle JDBC driver, i.e not via SQLPLus* ?

Update 1: Driver: ojdbc14 (JDBC)

Update 2: Change is being applied to oracle via Ant <SQL> task, which is passed a sql script file.

In this instance using SQLPlus in the Ant script is not possible (long story).

Upvotes: 1

Views: 887

Answers (1)

dpbradley
dpbradley

Reputation: 11925

Yes, the standard Ant sql task will do this. These options are working for me:

sql driver="oracle.jdbc.driver.OracleDriver"
       delimiter="/"
       delimitertype="row"
       keepformat="yes"
       caching="true"
       escapeprocessing="no"

One thing I've found is that the processing is sensitive to the last line with the delimiter - if you have any whitespace after the "/" the execution will fail.

Upvotes: 1

Related Questions