SQL & PL/SQL

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!

sys_context( 'USERENV' , 'OS_USER') returns NULL

431952Sep 3 2006 — edited Sep 13 2006

Hi,

I would really appreciate your help with this wierd problem we are facing. We have some java code deployed on Weblogic 8 that calls a oracle stored procedure. The oracle stored procedures uses sys_context( 'USERENV' , 'OS_USER') to capture the OS user calling the proc and stores it in a database table.

The problem we are facing is sys_context( 'USERENV' , 'OS_USER') is returning NULL.

Has any one faced this problem before. how did you fix it ?

Thanks a lot for your help

Thanks and Regards,
Smita

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2006

Added on Sep 3 2006

4 comments

975 views