This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes database procedures Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "database procedures" Watch "database procedures" New topic
Author

database procedures

Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
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

Joined: May 26, 2003
Posts: 32507
    
214

What exception do you get?


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Grace Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
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 Green
Ranch Hand

Joined: Nov 08, 2010
Posts: 79
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?
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: database procedures
 
It's not a secret anymore!