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 -> Re: how would you do it?

Re: how would you do it?

From: klabu <klabu76_at_gmail.com>
Date: Fri, 15 Dec 2006 17:47:55 -0500
Message-ID: <12o69gsievtj155@corp.supernews.com>

"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

Original text of this message

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