Re: Parameters in function

From: Mark D Powell <mark.powell_at_eds.com>
Date: 8 Mar 2002 06:35:26 -0800
Message-ID: <178d2795.0203080635.5b65e180@posting.google.com>

<kazelot_at_thenut.eti.pg.gda.pl> wrote in message news:<Pine.LNX.3.96.1020308084637.484B-100000_at_thenut.eti.pg.gda.pl>...
> I have read that function cannot can only have 'in' parameters?
> Is that true?
>
> TIA,
> kazelot

UT1> @cf
UT1> -- playing
UT1> --
UT1> set serveroutput on
UT1> create or replace function markfunc (

  2 p_v1 in varchar2
  3 ,p_v2 in out varchar2
  4 ) return number is
  5 --
  6 v_v1 varchar2(10) := 'Input' ;
  7 v_v2 varchar2(10) := 'Output' ;
  8 --
  9 begin
 10 --
 11 p_v2 := v_v2 ;
 12 return 1 ;
 13 end ;
 14 /

Function created.

UT1> declare

  2  v_pass1  varchar2(10) := 'Testing';
  3  v_pass2  varchar2(10) := null        ;
  4  v_rc        number    := 0        ;

  5 begin
  6 v_rc := markfunc(v_pass1,v_pass2) ;   7 dbms_output.put_line('RC => '||v_rc||' V_PASS2 => '||v_pass2) ;   8 end ;
  9 /
RC => 1 V_PASS2 => Output

PL/SQL procedure successfully completed.

Why ask what you can do?

HTH
-- Mark D Powell -- Received on Fri Mar 08 2002 - 08:35:26 CST