This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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.