wood burning stoves 2.0*
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

Josue Cedeno
Ranch Hand

Joined: Feb 06, 2001
Posts: 71
Currently I have a stored procedure which evaluates three scenarios and appends to a temporary table depending on the selection.
if 1
insert temp table
if 2
insert temp table
if 3
insert temp table
display temp table
On the command line this works fine, but when I call this stored procedure using the jdbc-odbc bridge I can only retrieve a resultset when the option is "3"
Any ideas?
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Josue
It could be any number of things, let us see the code and we can take a look at it.


Dave
Josue Cedeno
Ranch Hand

Joined: Feb 06, 2001
Posts: 71
I emailed the code. I really appreciate your help. I've tried isolating the problem and it still doesn't make sense.
Dave Vick
Ranch Hand

Joined: May 10, 2001
Posts: 3244
Josue
Sorry, I didn't realize that the actual problem was with a stored procedure, I thought it was with the java that called it. I am not a stored procedure expert so can't help you.
You might want to post the relevant sections here so someone else can check them out.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Problem with Stored Procedure