Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can one create a type (domain) and see it in the OEM type dropdown lists?

Re: Can one create a type (domain) and see it in the OEM type dropdown lists?

From: Lewis C <lewisc_at_excite.com>
Date: Mon, 09 May 2005 23:20:03 GMT
Message-ID: <6prv71dseq5g14p4jloq5oeq91u4akj0ph@4ax.com>


On 9 May 2005 05:52:12 -0700, "deanbrown3d" <deanbrown3d_at_yahoo.com> wrote:

>Look, the question I am asking is HOW to do the domain thing, not IF.
>We have 2 clients, possibly 3, and the 2 we have now pay millions of
>$$$$ for the software .So its hardly a big thing to satisfy their
>policies. Enough said on this please.
>
>D.

If it's just that one object and your code uses anchored variables, i.e. variable_name table_name.column_name%type, then you can generate the ddl and just change that one item. Keep the ddl for that table seperate for each client.

Someone mentioned versioning in designer and you could probably make that work but I don't think this one change is worth it. Just keep that item outside. You'll probably implement using scripts rather than directly from designer anyway, correct?

If you have to do it, keep it as simple as possible.

Hope that helps,

Lewis



Lewis R Cunningham

Author, ItToolBox Blog: An Expert's Guide to Oracle http://blogs.ittoolbox.com/oracle/guide/

Topic Editor, Suite101.com: Oracle Database http://www.suite101.com/welcome.cfm/oracle

Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752


Received on Mon May 09 2005 - 18:20:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US