APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can I retrieve an APEX user name from within the database?

aimeesAug 17 2012 — edited Sep 1 2012

I'm an old Portal developer trying to learn how to use APEX. My question is how can I retrieve a USER name from within the database once logged into APEX? Portal has a function called portal.wwctx_api.get_user that does this for you. I have conducted a number of queries to find an answer to this question. I've come across a number of people asking a similar question, but I haven't been able to find a solution.

I've tested V('APP_USER') and APEX_UTIL.GET_USERNAME, APEX_APPLICATION.G_USER. These items work on the APEX side, but don't seem to work from within the database. They retrieve generic APEX account information in the database.

Any advice would be appreciated.

Thank you:
Aimee

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2012

Added on Aug 17 2012

#11g, #apex, #apex-discussions, #plsql

20 comments

15,594 views