Re: HELP: Server/SQL

Khue Pham wrote:

> Thanks,
>
> I checked the datatype already. This is somewhat strange.
>
> Regards,
>
> Khue Pham
>
> "Kjell Tore Nannestad" <knannest_at_c2i.net> wrote in message
> news:3B604BD5.9060702_at_c2i.net...
> > 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
> > >
> > >
> > >
> >

I doubt it. Do a describe on all three tables and compare field types.

Daniel A. Morgan Received on Thu Jul 26 2001 - 12:40:46 CDT