Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing User Session variables in Reports 9i

Status
Not open for further replies.

rgaughran

IS-IT--Management
Apr 29, 2003
2
US
I have reports that I have created in Oracle 9iAS which are SQL based reports. I would like to reference the current User signed on in my SQL statements. Does anyone know how I can do this. I know there is an API package, wwctx_api, which I can use to get the userid (wwctx_api.get_user). But, 1. Can I reference this package within my report SQL, or is there a system variable, such as SYSDATE, that stores the current user signed on? Please advise.

Thanks, Rachel
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top