HELP: Server/SQL

From: Khue Pham <kp100012_at_ncr.com>
Date: Thu, 26 Jul 2001 12:00:22 -0400
Message-ID: <3b603ec6$1@rpc1284.daytonoh.ncr.com>

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:00:22 CDT