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 -> Out parameters in a procedure

Out parameters in a procedure

From: Tony Walby <tony.walby_at_bridgewatersystems.com>
Date: Tue, 04 Sep 2001 14:08:19 -0400
Message-ID: <3B951893.C6C26A6E@bridgewatersystems.com>


Could someone please explain to me how out parameters work in a procedure. For example if I had the following: create or replace procedure con_time (v_sysdate in data, v_DD out number,
v_HH out number) as
begin
select to_number(to_char(v_sysdate, 'DD' )) into v_DD from dual; select to_number(to_char(v_sysdate, 'HH24' )) into v_HH from dual; end;
/

Lets say this compiled without errors (There may be errors in this one) lets just say it compiled and I execute it how do I see the returned values ?

Tony Received on Tue Sep 04 2001 - 13:08:19 CDT

Original text of this message

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