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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to pass procedures as parameters?

Re: How to pass procedures as parameters?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 23 Mar 1999 09:35:44 +0800
Message-ID: <36F6EFF0.6F9C@bhp.com.au>


earthlink wrote:
>
> can any one tell me how to pass a procedure as a parameter,
> and execute it in the called program.
>
> TIA
>
> Phil

create or replace

procedure my_proc(p_incoming_parm  number,
                  p_outgoing_only_parm out number,
                  p_in_and_outgoing in out number) is
begin
 ...
end;

called with:

my_proc(12,var1,var2)

HTH
--



Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Mon Mar 22 1999 - 19:35:44 CST

Original text of this message

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