Create Type

From: Brady, Mark <Mark.Brady_at_Constellation.Com>
Date: Tue, 23 Dec 2008 15:55:13 -0500
Message-ID: <1BB5C9CF81E4FB4F8FFED437AA3E5D635CEEC4652A@EXM-OMF-02.Ceg.Corp.Net>

CREATE TYPE yourtype OID '19A57209ECB73F91E03400400B40BBE3'   AS OBJECT (your_id NUMBER);

The CREATE TYPE syntax has an optional OID clause which, in theory allows types on separate instances to be seen as identical, but what can you do with them?

I can't see a use for this.

I create the above type on two different instances. I have a function that returns that type on one instance and I try to call that function over a dblink and fill that "identical" type on a second instance and it fails.

If it can't do that, what is it good for?
>>> This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP2

Received on Tue Dec 23 2008 - 14:55:13 CST

Original text of this message