-
session variables
Dear developers,
I would like to make an Audit Table, but I do not want to send the information from the application I want it to be extracted from the Database, from the session ? what are the variables that I can extract friom session from example can I extract the PC Network name from the session. :confused:
Thanks
Aiman H. Al-Jumoay
-
Check ora_dic_obj_name
but sorry i am not sure
regards,
Praveen
-
userenv or sys_context functions
-
"can I extract the PC Network name from the session"
Partly comes down to how the end user connects to the database. If there is something in between (eg an application server) all the database knows is that the connection is from the application server (plus anything the application server 'tells it', but obviously that is part of the application).