Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to change the USERID variable?

How to change the USERID variable?

From: Rob Edgar <robedgar_at_hkstar.com>
Date: Thu, 30 Jul 1998 16:42:16 +0800
Message-ID: <6ppbgp$qd71@news.hk.linkage.net>


Is there a way by using PL/SQL to change the USERID variable.

We have people who will be consecutively sharing a permanently logged in connection and we would like to be able to reassign the variable as the connction gets allocated out to a user mainly so we can continue to use it in triggers etc that store the value USERID.

I know I could achieve the same thing with a package variable but it would be a little bit neater if I could set the USERID var instead of creating my own.

Ok I know its a long shot but if anyone knows the answer I will be grateful for a response.

Rob Received on Thu Jul 30 1998 - 03:42:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US