Re: rare error

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 29 Mar 2001 20:09:15 +0200
Message-ID: <tc710u9f7v8tcc@beta-news.demon.nl>

"Zhiliang Hu" <zhu_at_genomicfx.com> wrote in message news:3AC36B16.889B3065_at_genomicfx.com...
> I have a SQL query that works well:
>
> select a.animalid, b.allele1, b.allele2 from animal_hr a, genotype_hr
> b
> where a.plate=b.plate AND a.well=b.well AND raw>'900';
>
> However, when I tried portion of the same query:
>
> select a.animalid, b.allele1, b.allele2 from animal_hr a, genotype_hr
> b
> where a.plate=b.plate AND a.well=b.well;
>
> Oracle complains:
> -------------------------------------------
> "where a.plate=b.plate AND a.well=b.well
> *
> ERROR at line 2:
> ORA-01722: invalid number
> -------------------------------------------
>
> Isn't it strange?
>
> Zhiliang
>

Evidently there must be some implicit type conversion going on. Please compare the datatypes of the affected columns.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Mar 29 2001 - 12:09:15 CST