Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL: ORA-00920: invalid relational operator" Error
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
![]() |
![]() |