Oracle PL/SQL: FUNCTIONS: IN OUT parameter - When you create a procedure or function, you may define parameters. There are three types of paramet

Quick Search:

Oracle PL/SQL: FUNCTIONS: IN OUT parameter

Jump to:

Category: >> Oracle PL/SQL >> FUNCTIONS: IN OUT parameter

<< last

next >>

Snippet Name: FUNCTIONS: IN OUT parameter

Description: When you create a procedure or function, you may define parameters. There are three types of parameters that can be declared:

1. IN - The parameter can be referenced by the procedure or function. The value of the parameter can not be overwritten by the procedure or function.

2. OUT - The parameter can not be referenced by the procedure or function, but the value of the parameter can be overwritten by the procedure or function.

3. IN OUT - The parameter can be referenced by the procedure or function and the value of the parameter can be overwritten by the procedure or function.

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 13th, 2009

CREATE [OR REPLACE] FUNCTION function_name
    [ (parameter [,parameter]) ]
    RETURN return_datatype
IS | AS
    [declaration_section]
BEGIN
    executable_section
[EXCEPTION
    exception_section]
END [function_name];
 
 
-- example:
 
CREATE OR REPLACE FUNCTION inout_fn (outparm IN OUT VARCHAR2)
RETURN VARCHAR2 IS
 
BEGIN
  outparm := 'Coming out';
  RETURN 'return param';
END inout_fn;
/
 
SET serveroutput ON
 
DECLARE
  retval VARCHAR2(20);
  ioval  VARCHAR2(20) := 'Going in';
BEGIN
  DBMS_OUTPUT.put_line('In: ' || ioval);
  retval := inout_fn(ioval);
  DBMS_OUTPUT.put_line('Out: ' || ioval);
  DBMS_OUTPUT.put_line('Return: ' || retval);
END;
/