Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem with Stored Procedure

 
Josue Cedeno
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Josue
It could be any number of things, let us see the code and we can take a look at it.
 
Josue Cedeno
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic