Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What is the best approach to process data on row by row basis ?

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

From: <krislioe_at_gmail.com>
Date: 17 Nov 2006 22:08:49 -0800
Message-ID: <1163830129.051113.308130@k70g2000cwa.googlegroups.com>


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 Received on Sat Nov 18 2006 - 00:08:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US