Oracle PL/SQL: FUNCTIONS: with output parameters - This is a sample of a function that outputs a parameter.

Quick Search:

Oracle PL/SQL: FUNCTIONS: with output parameters

Jump to:

Category: >> Oracle PL/SQL >> FUNCTIONS: with output parameters

<< last

next >>

Snippet Name: FUNCTIONS: with output parameters

Description: This is a sample of a function that outputs a parameter.

Comment: (none)

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

CREATE OR REPLACE FUNCTION out_fn (outparm OUT VARCHAR2)
RETURN VARCHAR2 IS
 
BEGIN
  outparm := 'out param';
  RETURN 'return param';
END out_fn;
/
 
SET serveroutput ON
 
DECLARE
  retval VARCHAR2(20);
  outval VARCHAR2(20);
BEGIN
  retval := out_fn(outval);
  DBMS_OUTPUT.put_line(outval);
  DBMS_OUTPUT.put_line(retval);
END;
/