File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "problem with stored procedure......." Watch "problem with stored procedure......." New topic

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...

thanx in advance,
Yogen Vadnere
Ranch Hand

Joined: Sep 20, 2001
Posts: 58
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:
subject: problem with stored procedure.......
It's not a secret anymore!