Re: Value returned from user function

From: Peter Mckenzie <Peter.McKenzie_at_health.wa.gov.au>
Date: 2000/05/17
Message-ID: <8fsvdm$mtr$1@nnrp1.deja.com>#1/1

Create a Database package with a variable in the header. Create a procedure in the body of the package to set this variable e.g. set_my_user (my_choice_of_user_name varchar2) Create a function e.g. my_user to retrieve the variable. Call the set_my_user procedure at the start of the users session. Once set this variable will be retained for the duration of the users session.

Good luck,

Peter McKenzie

In article <8fsf20$4mq$1_at_nnrp1.deja.com>, alanpol_at_my-deja.com wrote:
> For the duration of a session, we'd like to get 'user' to return a
> specific string which is not the actual username...>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed May 17 2000 - 00:00:00 CDT