Re: HELP: Server/SQL

Usually the error is that the columns in the where clause is of different types, eg. date and varchar2.

Khue Pham wrote:

>Greetings,
>
>Our test database (WATD) here is linked to WATTST by a public database link
>call SSFD. When I tried this query:
>
>SELECT po.vat_code, po.vendor_id,
> ps.vendor_site_id,
> ps.accts_pay_code_combination_id,
> SUBSTR(po.invoice_currency_code,1,3),
> SUBSTR(po.vendor_name,1,30)
>FROM po_vendors_at_ssfd po, po_vendor_sites_all_at_ssfd ps, parameters pa
>WHERE po.vendor_id = ps.vendor_id
> AND ps.pay_group_lookup_code = pa.pay_group_type
> AND po.segment1 = '3411'
> AND ps.inactive_date IS NULL
> AND pa.parameter_key = 1
>
>I got the error:
>
>ERROR:
>ORA-01858: a non-numeric character was found where a numeric was expected
>ORA-02063: preceding line from SSFD
>
>If I remove any (AND somthing = something) in the WHERE clause then it
>works. It is very strange. Does anyone have any idea/suggestion ? (I
>re-type the whole statement manually but the error is still the same).
>Someone suggest that it may be the Oracle Server (since it work on her
>machine). The Oracle version we are using is 7.3.4 and it is on NCR UNIX
>MP-RAS 3.02
>
>
>
Received on Thu Jul 26 2001 - 11:50:02 CDT