Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL: ORA-00920: invalid relational operator" Error

PL/SQL: ORA-00920: invalid relational operator" Error

From: DotNetDoctor <DotNetDoctor.1xxtbs_at_no-mx.forums.yourdomain.com.au>
Date: Wed, 2 Nov 2005 08:57:20 -0500
Message-ID: <DotNetDoctor.1xxtbs@no-mx.forums.yourdomain.com.au>

PL/SQL: ORA-00920: invalid relational operator" Error --- :confused:

Please Tell me if you can resolve this "PL/SQL: ORA-00920: invalid relational operator" Error in the :- code :-

DECLARE BSSS_HighPr VARCHAR2(11);

BSSS_LowPr VARCHAR2(11);

IF ACCOUNT_ROW.tax2_id IN
(999999999,888888888,777777777,666666666,555555555,444444444,333333333,222222222,111111111)

AND ACCOUNT_ROW.tax1_id IS NULL

AND ACCOUNT_ROW.tax2_id IS NOT NULL

THEN Tax_Id_where_clause := 'A.TAX_ID = ' || ACCOUNT_ROW.tax2_id;

SELECT MAX(to_number(TRD_PR)),MIN(to_number(TRD_PR)) INTO BSSS_HighPr,BSSS_LowPr

FROM BS_TRADE WHERE Tax_Id_where_clause /* ---- gETTING ERROR here ---- */

GROUP BY TRD_PR,TRD_DT; PLEASE reply :confused: :confused:

-- 
DotNetDoctorMessage posted via  http://www.exforsys.com for all your training needs.
Received on Wed Nov 02 2005 - 07:57:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US