View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 06:17 PM
Raquel
 
Posts: n/a
Default Java stored procedure error ....

Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP.
I am new to stored procedures.

The stored procedure code I am using is at:
https://www6.software.ibm.com/dw/edu...b2spdc/sp.java

I was able to successfully 'build' the stored procedure that I created
using Development Center, however, at run time it is showing the
following error:

A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL4302N
Java stored procedure or user-defined function
"DB2ADMIN.CHECKRETAILERCREDIT", specific name "SQL040608143836354"
aborted with an exception "". SQLSTATE=38501

Can someone let me know what this error is or is there any way we can
start a trace or something similar in Java to find out more details
about this error.

TIA
Raquel.
Reply With Quote