Re: What is the best approach to process data on row by row basis ?

Hi,

best approach means most efficient.

Dont want to use cursor because cursor is only used when there is no other way of doing the job.

Is the algorithm I describe above best implemented using cursor ?

Thanks ,
xtanto

Jaap W. van Dijk wrote:
> On 17 Nov 2006 22:08:49 -0800, krislioe_at_gmail.com wrote:
>
> >Hi Gurus,
> >
> >I need to code stored proc to process sales_orders into Invoices. I
> >think that I must do row by row operation, but if possible I don't want
> >to use cursor. The algorithm is below :
> >
> >for all sales_orders with status = "open"
> >
> > check for credit limit
> > if over credit limit -> insert row log_table; process next order
> > check for overdue
> > if there is overdue invoice -> insert row to log_table; process
> >next order
> > check all order_items for stock availability
> > if there is item that has not enough stock -> insert row to
> >log_table; process next order
> >
> > if all check above are passed:
> > create Invoice (header + details)
> >
> >end_for
> >
> >What is the best approach to process data on row by row basis like
> >above ?
> >
> >Thank you for your help,
> >xtanto
> >
> What are your criteria for "best approach"?
> What do you mean by "don't want to use cursor"?
>
> Regards, Jaap.
Received on Sat Nov 18 2006 - 05:07:07 CST