Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to capture context from a database link?
On Mon, 23 Aug 2004, makbo_at_pacbell.net wrote:
> Galen Boyer wrote: >
On the remote instance:
CREATE OR REPLACE function sysguid
RETURN varchar2 AS v_sysguid varchar2(2000); BEGIN select cast(sys_guid() as varchar2(2000)) into v_sysguid from dual ; RETURN v_sysguid; END;
On the local instance:
variable v_sysguid varchar2(2000);
exec :v_sysguid := sysguid_at_somedblink;
-- Galen BoyerReceived on Tue Aug 24 2004 - 08:57:15 CDT