aspose file tools*
The moose likes JDBC and the fly likes problem with stored procedure....... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem with stored procedure......." Watch "problem with stored procedure......." New topic
Author

problem with stored procedure.......

lusha tak
Ranch Hand

Joined: Dec 30, 2000
Posts: 185
Hi all!
I tested my stored procedure in SQL query analyser & I get the expected return value.. but while retrieving it at the front end with callable statement in a string I always get empty string . If I try to retrieve it in integer variable then also as I don't get any returnvalue I get the Null pointer exception.

please do communicate the solution to me ASAP if u have found one....
thanks in advance...
Lusha

thanx in advance,
Yogen Vadnere
Ranch Hand

Joined: Sep 20, 2001
Posts: 58
Lusha,
If possible pl post ur code where ur calling store procedure, setting IN and OUT parameter. I guess ur missing some order in this.

Yogen Vadnere
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem with stored procedure.......