RPG SQL stored procedure called from java

["Bill Grossenbacher" <Bill.Grossenbacher@xxxxxxxxxxxxxxx>]

We have an RPGSQL program that is used as a stored procedure. The text to 
create the stored procedure is 

CREATE PROCEDURE AIPDFVIEW 
(                          
  In    TRKID Char(29),    
  In    PCUNO dec(7,0),    
    OUT PCOUNT DEC(4,0)    
)                          
                           
Result sets 1              
Language RPGLE             
External name AIPDFVIEW    


 

IBM's DB2 development center never has a problem running the stored procedure. 

When the stored procedure is called by a java process that uses the result, a 
sporadic cursor state error occurs that indicates to the java process an error 
happened when actually the RPG program ran correctly and should have returned 
the result set requested.

The question that I have is .... Is there something wrong with the create 
listed above. 

Thanks

Bill Grossenbacher
IT Project Manager
USA Mobility
601.977.1583
Bill.Grossenbacher@xxxxxxxxxxxxxxx