CODEWITHSUNDEEP
sqloracle-databaseantplsqloracle10g
Jacob
Jacob

Reputation: 14731

PLS-00103: Encountered the symbol / when execute from ant build

I have sql script which contains package spec and body and each one of them is separated by forward slash / This executes fine when I run from sql plus or Sql Developer.

When I execute from ant build, sql scripts executes fine and build is successful. However package has errors with PLS-00103: Encountered the symbol /. My ant build script for sql is as follows

<target name="sql">        
      <sql driver="${sql.driver}" url="${sql.url.test}" 
      userid="${sql.user}" password="${databasepassword}" 
      classpathref="antclasspath" keepformat="true" 
      delimitertype="row">
      <transaction src="create.sql"/>          
      </sql>
   </target>

How can I resolve this error? Any help is highly appreciable.

Thanks

Upvotes: 1

Views: 886

Answers (1)

Petr Pribyl
Petr Pribyl

Reputation: 3575

Try to set delimitier to "/". You have than to chane your script to end all commands with "/", not only PL/SQL, but it should work.

Upvotes: 1

Related Questions