Home » SQL & PL/SQL » SQL & PL/SQL » SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result
SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658142] Mon, 05 December 2016 11:48 Go to next message
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
Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658143 is a reply to message #658142] Mon, 05 December 2016 11:59 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
value is establish by DBMS_APPLICATION_INFO.SET_CLIENT_INFO
Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658144 is a reply to message #658142] Mon, 05 December 2016 12:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Where is the copy and paste of your session?

Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658145 is a reply to message #658142] Mon, 05 December 2016 13:05 Go to previous messageGo to next message
John Watson
Messages: 7620
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 Go to previous messageGo to next message
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
Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658148 is a reply to message #658147] Mon, 05 December 2016 15:20 Go to previous messageGo to next message
BlackSwan
Messages: 26204
Registered: January 2009
Location: SoCal
Senior Member
https://community.oracle.com/thread/3996702
Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658152 is a reply to message #658148] Mon, 05 December 2016 23:08 Go to previous messageGo to next message
pcouas
Messages: 112
Registered: February 2016
Senior Member
Hi,

This link it's me too.


Regards
Re: SYS.DBMS_APPLICATION_INFO.READ_CLIENT_INFO bad result [message #658157 is a reply to message #658152] Tue, 06 December 2016 01:03 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

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


Current Time: Sun Oct 21 04:08:38 CDT 2018