GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

sys context (client_info is resulting some wrong result while using db link)

edited Jan 11, 2011 10:19PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
 procedure created in central db and in central db result is showing as expected, but when we try to access the same procedure from remote db using db link it shows wrong result, Please find the details below:
logged on using qicat_z user:(local where the procedure created)

Myowner format: session_user/host/os_user

When below stub is executed from sql Navigator in D/Q

declare
myowner VARCHAR2 (50);

begin
myowner := USERENV ('client_info');

IF myowner IS NULL
THEN
qicat_z.sp_qicat_set_user;
myowner := USERENV ('client_info');

IF myowner IS NULL
THEN
myowner := USER;
END IF;
END IF;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center