Erreur :ORA-00932: inconsistent datatypes

I try to open a cursor in a pl/sql package

PROCEDURE get_retail_price(P_CINV IN NUMBER, 
                           P_SITE IN NUMBER,
                           P_DATEP IN DATE,
			   P_RETOUR OUT NUMBER ) IS

CURSOR C_PV( V_CINV IN NUMBER,
	     V_SITE IN NUMBER,
	     V_DATE IN DATE) IS
	
SELECT AVONTAR, AVORESID, AVORESCINT, AVOIDSTR, AVOSTRCINT, AVOPRIO,
	AVODDEB, AVODFIN, AVIDDEB, AVIDFIN, AVIPRIX, AVISTAT, AVINDOS,

   	( SELECT OBJPERE, OBJCINT FROM STRUCREL 
   	  WHERE V_DATE BETWEEN OBJDDEB AND OBJDFIN ) 
   	 CONNECT BY PRIOR OBJPERE = OBJCINT START WITH OBJCINT = V_CINV ),
			( SELECT RELPERE P2,  RELID F2, LEVEL L2 FROM 
   				( SELECT RELPERE, RELID  FROM RESREL 
   				  WHERE V_DATE BETWEEN RELDDEB AND RELDFIN ) 
   			  CONNECT BY PRIOR RELPERE = RELID START WITH    
                                      RELID=  V_SITE )
		WHERE AVONTAR = AVINTAR AND 
			AVICINV = V_CINV AND 
			P1 = AVOSTRCINT AND 
			P2 = AVORESCINT AND 
			V_DATE BETWEEN AVIDDEB AND AVIDFIN AND 
			V_DATE BETWEEN AVODDEB AND AVODFIN
		ORDER BY AVOPRIO ASC, L1 ASC , L2 ASC, AVONTAR ASC;

When i open this cursor i have a ORA-00932 inconsistent datatypes I think i have a problem with the variable V_DATE and the comparator BETWEEN but i cant find a solution
i work with Oracle 8.1.7
thank you Received on Wed Jul 24 2002 - 11:50:20 CEST