Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: HELP: Server/SQL
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
> >
> >
> >
>
Received on Thu Jul 26 2001 - 12:04:56 CDT