Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can one create a type (domain) and see it in the OEM type dropdown lists?
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
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
![]() |
![]() |