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

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 - 04:19:36 CST