CoderZone.org

Category: >> Oracle PL/SQL >> PACKAGES: one function Bookmark and Share

<< lastnext >>

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)

Author: CoderZone
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;
/
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 5