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?
Josue It could be any number of things, let us see the code and we can take a look at it.
Joined: Feb 06, 2001
I emailed the code. I really appreciate your help. I've tried isolating the problem and it still doesn't make sense.
Joined: May 10, 2001
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.