Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to change the USERID variable?
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
![]() |
![]() |