This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Procedure Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Procedure Error" Watch "Procedure Error" New topic

Procedure Error

Eshwar Prasad
Ranch Hand

Joined: Mar 21, 2008
Posts: 202

i have requirement to delete huge data where i have to select data into small pieces and then delete it to avoid overload on database server. I have written a procedure for this, but it is not giving right output. I am getting error saying "one or more records are fetched". Can you please let me know where am i wrong.

here mytest table has 3 lakhs records. I want to select 1000 records everytime and delete them. Please help me.>
Eshwar Prasad
Ranch Hand

Joined: Mar 21, 2008
Posts: 202
any help?
Fatih Keles
Ranch Hand

Joined: Sep 01, 2005
Posts: 182
Hi Eshwar,

I really did not understand your procedure. Why don't you just use something like this?
I agree. Here's the link:
subject: Procedure Error
Similar Threads
Help required on Stored Procedure
Execution of stored procedure using for loop
Callable Statement
Hibernate doesn't use Oracle's native isolation levels