Oracle PL/SQL: PACKAGES: one function - Packages can hold functions as well as procedures. Here is a simple example.

Quick Search:

Oracle PL/SQL: PACKAGES: one function

Jump to:

Category: >> Oracle PL/SQL >> PACKAGES: one function

<< last

next >>

Snippet Name: PACKAGES: one function

Description: Packages can hold functions as well as procedures. Here is a simple example.

Also see:
» PACKAGES: initialization
» PACKAGES: related queries
» PACKAGES: alter package
» PACKAGES: overloading
» PACKAGES: one procedure
» UTL_FILE file write to file example
» Create Package
» UTL_FILE import data

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 10th, 2009

CREATE OR REPLACE PACKAGE test2 AS
FUNCTION GetUser RETURN VARCHAR2;
END test2;
/
 
CREATE OR REPLACE PACKAGE BODY test2 AS
FUNCTION getuser RETURN VARCHAR2 IS
 vOSUser user_users.username%TYPE; 
BEGIN
  SELECT osuser
  INTO vUser
  FROM sys.v_$session
  WHERE sid = (
    SELECT sid 
    FROM sys.v_$mystat 
    WHERE ROWNUM = 1); 
  RETURN vUser; 
EXCEPTION
  WHEN OTHERS THEN
    RETURN 'Not Known';
END getuser;
END test2;
/