How is the database session obtained/maintained ?
Posted: Mon 17 Aug 2009 09:29
How is the database session obtained/maintained using devart.
I want to obtain the following:
When an application start log onto the database
Today we call OCISessionBegin and then link the database session with our user table
This means that when executing stored procedures we have created a function
identifyUserAndGroup(l_userId, l_userName, l_groupId, l_groupName),
which is used to automatically fill out fields with who created, updated, owns various fields
Once the web request is over or the application stops OCISessionEnd is called.
How could the same functionality we obtained using devart, being able to
insure that all calls to Oracle is using the same underlying session.
What would be the correct approach?
Thanks in Advance
I want to obtain the following:
When an application start log onto the database
Today we call OCISessionBegin and then link the database session with our user table
This means that when executing stored procedures we have created a function
identifyUserAndGroup(l_userId, l_userName, l_groupId, l_groupName),
which is used to automatically fill out fields with who created, updated, owns various fields
Once the web request is over or the application stops OCISessionEnd is called.
How could the same functionality we obtained using devart, being able to
insure that all calls to Oracle is using the same underlying session.
What would be the correct approach?
Thanks in Advance