Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic update of cursor records
What the heck does:
* While processesing the current row of the cursor, the table is
> updated. This update will affect the as yet unprocessed rows in the
> cursor.
mean?
A better approach would be to state the problem or business need. Then we
can offer a solution. I have often seen requirements that did not state
what the problem was that they were trying to solve and just the solution.
Often what happens is that the real business need is not solved, but the
requirement is met. (people are unhappy)
Jim
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Jayprakash" <JayprakashKA_at_hotmail.com> wrote in message
news:eebcb735.0302040134.6a2b9617_at_posting.google.com...
> Hi!
>
> I have a requirement such that:
> * A set of records from a particular table are selected by a cursor
> * While processesing the current row of the cursor, the table is
> updated. This update will affect the as yet unprocessed rows in the
> cursor.
> * These changes need to be reflected in the cursor rows, when we fetch
> those rows.
>
>
> How do we make this happen?
>
> Thanks in advance.
>
> Regards,
> Jayprakash
Received on Tue Feb 04 2003 - 09:32:14 CST