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
Thanks, Rachel