Strange behavior by MySQL Stored Procedure

[Manasi Save]

Dear All,
 
I have one stored procedure Which inserts data into one table.
 
But sometimes it does not insert record. This happens when I called it from java application. But If I called same query from mysql command line. It executes successfully.
 
Also I have one procedure which only retrieves data from table. and it only gives one row sometime even if there are 10 rows available in for matching condition. This too happen when I called it from Java application and if I called it from mysql command line it gives me proper result set of 10 rows.
 
I am not able to understand Is it something known for mysql? Or am I doing something wrong?

Any input will be a great help.
 
--
Thanks and Regards,
Manasi Save