Re: HELP: Server/SQL

From: Khue Pham <kp100012_at_ncr.com>
Date: Thu, 26 Jul 2001 15:36:51 -0400
Message-ID: <3b6071da$1@rpc1284.daytonoh.ncr.com>

Hi Daniel,

Below are desc of 3 tables (I just trim off the unrelevant fields). They all look alright to me. Any other suggestion ?

SQLWKS> desc parameters

Column Name                        Null?             Type
------------------------------ --------         ----
PARAMETER_KEY             NOT NULL  NUMBER(1)
PAY_GROUP_TYPE                                 VARCHAR2(25)

....

SQLWKS> desc po_vendors

Column Name                         Null?                Type
------------------------------  --------            ----
VENDOR_ID                         NOT NULL    NUMBER
SEGMENT1                           NOT NULL    VARCHAR2(30)

.....

SQLWKS> desc po_vendor_sites_all

Column Name                         Null?                Type
------------------------------  --------             ----
VENDOR_ID                         NOT NULL     NUMBER
INACTIVE_DATE                                          DATE
PAY_GROUP_LOOKUP_CODE                  VARCHAR2(25)

....

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote in message news:3B60561E.7ED2C5F9_at_attws.com...
> 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 - 14:36:51 CDT