0

I have maven based project and I try to use sql-maven-plugin in order to setup/tear-down DB for system tests. I put in sqlCommand element:

CALL SOME_STORED_PROC('SYSTEST')

however, maven build fails on this SQL with the followig exception:

org.apache.maven.lifecycle.LifecycleExecutionException: ERROR: Function 'SOME_STORED_PROC(UNKNOWN)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts

I suspect that the argument of the stored procedure needs to be escaped in some special way. I failed to find any docs/ examples.

Any thoughts?

Aviad

Tunaki
  • 132,869
  • 46
  • 340
  • 423
aviad
  • 8,229
  • 9
  • 50
  • 98
  • 1
    Perhaps you should post the relevant pom snippet. Possibly maven is unable to find the stored procedure. – Raghuram Jan 31 '11 at 05:52

1 Answers1

0

The argument to stored procedure needs to be double guoted. that actually helped the situation

aviad
  • 8,229
  • 9
  • 50
  • 98