Re: How to capture context from a database link?

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 23 Aug 2004 23:44:41 GMT
Message-ID: <JjvWc.11360$sS2.3296@newssvr29.news.prodigy.com>

Galen Boyer wrote:

> On 20 Aug 2004, jared_at_hwai.com wrote:
>

>>Galen Boyer <galenboyer_at_hotpop.com> wrote in message
>>news:<ullgaoq2c.fsf_at_standardandpoors.com>...
>>
>>
>>>First things first.  This is wrong design.  You are putting
>>>intelligence in keys.  A definitely bad thing to do.  The
>>>domain needs to be an attribute on the table being inserted.
>>
>>No, not an intelligent key, just a way to guarantee uniqueness
>>when combining sequence-generated numbers from multiple
>>databases.

>
>
> Well, then why didn't you ask that?
>
> sys_guid()
>

Doesn't work across a dblink.

--Mark Bole Received on Mon Aug 23 2004 - 18:44:41 CDT