Packages: One Function

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

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;
/

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.