I am using jdbc adapter in my integration and I need to run the stored procedure on the Oracle Db. First I used the Stored Procedure template to run but I was unable to run ,webmethods was giving me some kid of Oracle error .but when that stored procedure
Run through Toad and SQL Plus Its running fine.
Then I planned to use Dynamic JDBC adapter service Template to run the same stored procedure but this time i am just giving statement
exec Procedure name
and this time I am getting different error…
[wm-cjdbc33-0009][Oracle JDBC Driver][Oracle]ORA-00900: invalid SQL statement
does any one was successful in running stored Procedure though this Dynamic adapter service?
I will appreciate your response.