Skip to Main Content

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!

USERENV('CLIENT_INFO') getting strange values

504757Dec 7 2007 — edited Dec 7 2007
We are using Oracle seeded view HZ_CUST_ACCT_SITES in our custom page to fetch some customer related information. It got the following WHERE clause

NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99);

USERENV('CLIENT_INFO') expects the value of ORG_ID.


When we do the transactions first few times, it is getting the correct ORG_ID value in the CLIENT_INFO. But after few transactions, it is suddenly getting the following value,

"Connect: Please kill this session (trys = 8)"


Then it starts throwing "ORA-01722: invalid number" exception.

Do you have any idea what program or job in database or Oracle Apps set this value?
Or how to debug to find which program actually sets this value?

Thanks a million in advance.

Regards
Sreeram.H
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2008
Added on Dec 7 2007
1 comment
1,365 views