Re: Username in PL/SQL

From: Gary O'Keefe <>
Date: Thu, 26 Aug 1999 11:49:26 GMT
Message-ID: <>

A keyboard was whacked upside Edward Beemer's head and out came:

>Hello guys,
>How can I use the username of the currently logged on user in a PL/SQL
>I would like to call some function with the current username as a parameter.

What, like this?

  set serveroutput on


    function_result number;

    function test(name in char) return number is     begin

      return 1;

    end test;




The expression 'user' always holds the session's username and is immutable. Hope that helps.


Gary O'Keefe

You know the score - my current employer has nothing to do with what I post
Received on Thu Aug 26 1999 - 13:49:26 CEST

Original text of this message