Re: non-constant comparisons in where clauses

From: Dave Wotton <Dave.Wotton_at_no-spam.it.camcnty.gov.uk>
Date: 28 Aug 1998 08:21:24 GMT
Message-ID: <6s5pa4$sot$1@dns.camcnty.gov.uk>

> From: Kevin Skaalrud <kevin_skaalrud_at_neptune.serca.com>
> Date: Thu, 27 Aug 1998 15:45:10 -0700

>select cm.name, cm.desc, sa.sales98, sa.sales99,
> sa.sales99 - sa.sales98 diffsales
>from v_sales sa, cms cm
>where (sa.custno = cm.id) and (cm.active != 'I') and (sa.sales98 >
>(sa.sales99 * 3));
>
>Compiles ok, but results in the runtime error:
>ORA06502: PL/SQL: numeric or value error.

Ah! - Your SQL is fine. All that's wrong is that for at least one of the rows in your table, either sales98 or sales99 contains a non-numeric value. Check your data.

Dave.
--
Remove the no-spam bit from my email address to reply. Received on Fri Aug 28 1998 - 03:21:24 CDT