load stored proc from ant.

[dragonGoget]

Hi,

I try to upload store procedure from ant build.xml...

My problem is that i have wrote a simple store proc as a test example (which is just a select count on a table) from DB2 Development Center and it is working well when it is executed from DB2 Development Center.

But, when i try to execute the same stored proc code from ant or from Quantum i receive the same kind of error:

--------- here is my stored procedure--------------
CREATE PROCEDURE EMSPGM.testSelect ( )
DYNAMIC RESULT SETS 1

P1: BEGIN
DECLARE cursor1 CURSOR WITH RETURN FOR
select count(fmt_id) from em.vems_inspect;

OPEN cursor1;
END P1
-----------------------------------------------------------------

why my stored proc is running from DB2 Development Center without any error and i get error from Quantum or ant build.xml ....

with my ant build.xml i get the same error than when i try to executed from Eclipse data base plugin Quantum :

com.ibm.db2.jcc.c.sqlException: DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: END-OF-STATEMENT; from em.vems_inspect; JOIN <JOINED_TABLE>

could any body help me with this ?