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;
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;
0