Issue when calling Oracle functions and Procedure

What steps will reproduce the problem?
1.execute a script that calls an oracle function or procedure
2.Function already exists in the Database 
3.Using db deploy via a command line to call the script

What is the expected output? What do you see instead?
Error :Error as  -> ORA-00900: invalid SQL statement

What version of the product are you using? On what operating system?
3.0M3 release on Windows XP

Please provide any additional information below.
Below is the function call 
EXEC 
sp_da_script_logger('005','005_IT_PRJ017500_INSERT_INTO_SCREEN_FIELDS.sql',0,'ST
ART',NULL);

Detail error log

Applying #5: 005_IT_PRJ017500_INSERT_INTO_SCREEN_FIELDS.sql...
Failed to apply changes: com.dbdeploy.exceptions.ChangeScriptFailedException: 
change script #5: 005_IT_PRJ017500_INSERT_
INTO_SCREEN_FIELDS.sql failed while executing statement 1:
EXEC 
sp_da_script_logger('005','005_IT_PRJ017500_INSERT_INTO_SCREEN_FIELDS.sql',0,'ST
ART',NULL)
 -> ORA-00900: invalid SQL statement

com.dbdeploy.exceptions.ChangeScriptFailedException: change script #5: 
005_IT_PRJ017500_INSERT_INTO_SCREEN_FIELDS.sql fa
iled while executing statement 1:
EXEC 
sp_da_script_logger('005','005_IT_PRJ017500_INSERT_INTO_SCREEN_FIELDS.sql',0,'ST
ART',NULL)
 -> ORA-00900: invalid SQL statement

        at com.dbdeploy.appliers.DirectToDbApplier.applyChangeScript(DirectToDbApplier.java:56)
        at com.dbdeploy.appliers.DirectToDbApplier.apply(DirectToDbApplier.java:30)
        at com.dbdeploy.Controller.processChangeScripts(Controller.java:40)
        at com.dbdeploy.DbDeploy.go(DbDeploy.java:122)
        at com.dbdeploy.CommandLineTarget.main(CommandLineTarget.java:13)
Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
        at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
        at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:961)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1190)
        at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1726)
        at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1696)
        at com.dbdeploy.database.changelog.QueryExecuter.execute(QueryExecuter.java:22)
        at com.dbdeploy.appliers.DirectToDbApplier.applyChangeScript(DirectToDbApplier.java:54)
        ... 4 more
Original issue reported on code.google.com by prash...@gmail.com on 2 Mar 2012 at 9:39
kimptoc / dbdeploy

Issue when calling Oracle functions and Procedure #67
