This content has been marked as final. Show 2 replies
Here is a simple example of a plsql procedure to find the user logged into Portal:
1. log into Sqlplus as the portal DB user.
2. created the following procedure:
create procedure usertest
3. set serveroutput on
4. This should return the user logged in to Portal.
The api used here is wwctx_api.get_user. More information on this api can be found at: http://www.oracle.com/technetwork/middleware/portal/summary-154850.html