We are experiencing a very odd problem with java stored procedures
very specific to one machine. We are able to successfully build the
procedure through spb but when we try running the sp we get a
SQL4306N Java stored procedure or user-def
ined function "xxxx", specific name "yyyy" could
not call Java method "zzzzz", signature "". SQLSTATE=42724
The odd thing is that this has been working in the past and still does
on most of our individual machines except on this one windows box.
I do not know which configuration parameter I should look at if at
all thats where the problem could be. Could it be something to do with
the length of the sp name ? I know the max length is 18 characters
and we are well below that limit.
Any help in this regard would be highly appreciated. Thanks.