I have the following domain defined and in use by every column used to
store information on US dollars:

create domain MONEY_D as numeric(9,2);

I have found that some queries are now returning values in excess of
10M, which causes an 'arithmetic exception, numeric overflow, or
string truncation' error.

Is there any problem with modifying this domain to something like,
say, numeric(15,2)? I'm assuming that all of the tables with columns
currently defined with domain will automatically be updated without
problem? Are there any gotcha's I need to look out for?

I have rewritten a couple of queries to get around the problem by
casting the sum as numeric(15,2), but that is not a maintainable
situation.

tia,

Bob M..