Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database procedures

 
Grace Green
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does anyone know why when I run a database procedure directly through the debugger, I hit no exceptions; however, when I run it through code, I reach exceptions.
The input parameters are the same.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34084
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What exception do you get?
 
Grace Green
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jeanne Boyarsky wrote:What exception do you get?


TOO_MANY_ROWS.

What type of exception I get is not the problem. THe problem is that I do get the exception when I run the procedure through the code, but not when I run it through the SQL Developer debugger with the same input parameters of the code.
I wish I could get the exception when I run the procedure with the SQL Developer debugger ...
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would guess this is because you are connecting as different users.
 
Grace Green
Ranch Hand
Posts: 79
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the privileges are the same, though
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Do your two users have access to the same schema? i.e. does your exact fetch query access the same table, or a table with the same name (though possible different data) in the schema the users connects to?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic