CODEWITHSUNDEEP
sqlantplsqlsqlplus
user1797693
user1797693

Reputation:

Plsql statements not working with ANT

I have a file with the following content:

-- KERNEL72 - SWIFT Silver changes start

/*

drop synonym ispkss_vals
/

create synonym ispkss_vals for ispks_vals
/

*/-- KERNEL72 - SWIFT Silver changes ends after the below line

create or replace synonym ispkss_vals for ispks_vals
/

This is compiling properly in SQL Plus. But while compiling using ANT, I am getting the following error:

[sql] Failed to execute:

[sql] -- KERNEL72 - SWIFT Silver changes start
[sql] /*
[sql] drop synonym ispkss_vals
[sql] java.sql.SQLException: Invalid SQL type
[sql] Failed to execute:
[sql] create synonym ispkss_vals for ispks_vals
[sql] java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object [sql] Failed to execute:
[sql] */-- KERNEL72 - SWIFT Silver changes ends after the below line
[sql] create or replace synonym ispkss_vals for ispks_vals
[sql] java.sql.SQLSyntaxErrorException: ORA-00900: invalid SQL statement

Im using the following ANT scripts for compilation:

                  <sql driver="oracle.jdbc.driver.OracleDriver"
        url="jdbc:oracle:thin:@10.184.1.13:1521:UPP"
        userid="${UsernameB}"
        password="${PasswordB}"
        onerror="continue"
        strictDelimiterMatching="false"
        delimiter="/"
        keepformat="yes">

Please advice on why ANT compilations are not proper.

Upvotes: 1

Views: 958

Answers (1)

user1919238
user1919238

Reputation:

Perhaps the problem is that you are using / as the statement delimiter and also trying to comment with /* ... */?

It may be treating the comment opening and closing as delimiters, creating sql statements that don't make sense. (one would start with *, etc.)

Upvotes: 2

Related Questions