Re: HELP: Server/SQL

Khue Pham wrote:

> 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
> >

I may have sent a partial email a second ago and apologize to the group. There is a problem with your above definitions.

Where are the fields for:

> > > > SUBSTR(po.invoice_currency_code,1,3),
> > > > SUBSTR(po.vendor_name,1,30)
etc.?

Please send the actual definitions and I will duplicate it on one of my servers.

Daniel A. Morgan Received on Thu Jul 26 2001 - 15:28:15 CDT