OraFAQ Forum: SQL & PL/SQL » SYS.DBMS_APPLICATION_INFO.READ_CLIENT

Home » SQL & PL/SQL » SQL & PL/SQL » SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658142]

Mon, 05 December 2016 11:48

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi

In Oracle10XE Edition SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO(user_info); give me 'user'
But in Oracle12C SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO(user_info); give me '1830544380365345:user'

Why this number before user name ?

Regards
Phil

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658143 is a reply to message #658142]

Mon, 05 December 2016 11:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

value is establish by DBMS_APPLICATION_INFO.SET_CLIENT_INFO

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658144 is a reply to message #658142]

Mon, 05 December 2016 12:22

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Where is the copy and paste of your session?

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658145 is a reply to message #658142]

Mon, 05 December 2016 13:05

John Watson
Messages: 9002
Registered: January 2010
Location: Global Village

Senior Member

Your 12c example looks like an APEX session. When you say 'user' do you mean the schema logon or some sort of application user ID?

[Updated on: Mon, 05 December 2016 13:06]

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658147 is a reply to message #658142]

Mon, 05 December 2016 14:43

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

Perhaps, before i used Oracle10XE with APEX 4.0.2 and now my application using Oracle12C with APEX 5.0.4

Regards

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658148 is a reply to message #658147]

Mon, 05 December 2016 15:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://community.oracle.com/thread/3996702

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658152 is a reply to message #658148]

Mon, 05 December 2016 23:08

pcouas
Messages: 112
Registered: February 2016

Senior Member

Hi,

This link it's me too.

Regards

Report message to a moderator

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658157 is a reply to message #658152]

Tue, 06 December 2016 01:03

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And it gives the answer you didn't forward here, why?

Report message to a moderator

Previous Topic:	materialize view logs rfresh
Next Topic:	Correct order of data in Hierarchical Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 21:36:35 CDT 2026