Re: how would you do it?

"Eugene"
> Hi all,
> I have a table with 2 columns:
> seq proc
> ------ -------------------------
> 1 sales_order_p;
> 2 po_p;
> 3
> ........
>
> I need to be able to loop via all records in that table (ordered by
> seq) end execute each procedure.
> Is it possible? Do I use "execute immediate"?
> I want to make is dinamic enough so if another procedure will be added
> OR I will have to resequence table, no extra maintenance will be
> required.
>

I'd probly concatenance and do a
"execute immediate" on a anon block like this:

begin
  sales_order_p;
  po_p;
  invoice_p;
end ; Received on Fri Dec 15 2006 - 16:47:55 CST