Applying Oracle PL/SQL via JDBC

Question

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).

What driver are you talking about? JDBC? ODBC? ODP.Net? It is almost certainly possible. But we'll need more information in order to provide any specifics. — Justin Cave
– Justin Cave, Commented Oct 5, 2010 at 9:54

dpbradley · Accepted Answer · 2010-10-05 12:28:53Z

1

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.

answered Oct 5, 2010 at 12:28

dpbradley

12k2 gold badges33 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Applying Oracle PL/SQL via JDBC

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related