Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SW vendor insists on RBO
Hi Andy,
Yeah, you're right! They called it GHG_REF_CODES, indicating it was part of their GHG-module, but essentially it's the same table.
Peter
"Andy Hardy" <newsnov01_at_ahardy.demon.co.uk> schreef in bericht
news:jBvC3XN+Msu9Ew5L_at_ahardy.demon.co.uk...
> In message <aoq2l7$a7l$1_at_news.hccnet.nl> , Peter van Rijn
> <pgm.van.rijnRM_at_THIShccnet.nl> writes
>
> >We ran across a problem I never would have imagined: CBO provoked an
> >ORA-1722 (invalid number) error. I'll explain.
> >
> >We have this rather small table (the smallness is crucial) which is used
to
> >store (and query of course) domains. There is a column for low values,
one
> >for high values. The table is queried by supplying the domain name (which
is
> >part of an index) and supplying the low value field. Since the numeric
low
> >and high values are stored in a VARCHAR2 the to_number function is being
> >used to do the conversion. Now were getting close.
>
> Coo... this sounds like the cg_ref_codes table used by applications
> generated with Oracle Designer... ugly... spent a few hours wondering
> what had happened, but easy to fix by just dropping the statistics on
> that table.
>
> Andy
> --
> Andy Hardy. PGP ID: 0xA62A4849
Received on Mon Oct 28 2002 - 04:22:33 CST