Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Out parameters in a procedure
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