| Author |
database procedures
|
Grace Russo
Ranch Hand
Joined: Nov 08, 2010
Posts: 62
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26173
|
|
|
What exception do you get?
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
Grace Russo
Ranch Hand
Joined: Nov 08, 2010
Posts: 62
|
|
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
Joined: Apr 14, 2004
Posts: 10336
|
|
|
I would guess this is because you are connecting as different users.
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
|
Grace Russo
Ranch Hand
Joined: Nov 08, 2010
Posts: 62
|
|
|
the privileges are the same, though
|
|
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
|
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?
|
|
 |
|
|
subject: database procedures
|
|
|
0
