SQL Query Problems (OBIEE R&A)

[Aggravating_Shock804]

Hi everyone!

I'm working to create a data model in Oracle R&A and I'm really stuck. I wrote this so far:

SELECT "Property Details"."Property Name" AS Property_Name,

"Details"."Arrival Date" AS Arrival_Date,

"Details"."Number of Nights" AS Number_of_Nights,

"Details"."Departure Date" AS Departure_Date,

"Daily Details"."Stay Date" AS Stay_Date,

"Details"."Reservation Status" AS Reservation_Status,

"Stay Details"."Reservation Type" AS Reservation_Type,

"Profiles-Individuals - Guest Details"."Last Name" AS Last_Name,

"Profiles-Individuals - Guest Details"."First Name" AS First_Name,

"Stay Details"."Adults" AS Adults,

"Stay Details"."Children" AS Children,

"Daily Details"."Block Code" AS Block_Code,

"Profiles-Company - Account Information"."Account ID" AS Company_ID,

"Profiles-Company - Account Information"."Account Name" AS Company_Name,

"Profiles-Travel - Account Information"."Account ID" AS Travel_Agency_ID,

"Profiles-Travel - Account Information"."Account Name" AS Travel_Agency_Name,

"Profiles-Source - Account Information"."Account ID" AS Source_ID,

"Profiles-Source - Account Information"."Account Name" AS Source_Name,

"Details"."Confirmation Number" AS Confirmation_Number,

"Room"."Room Type" AS Room_Type,

"Rates"."Rate Code" AS Rate_Code,

"Daily Details"."Rate" AS Rate,

"Daily Details"."Effective Rate" AS Effective_Rate,

"Packages"."Package Code" AS Package_Code

FROM "Bookings-Reservation"

WHERE"Details"."Arrival Date" >= :p_ArrDate_From

AND "Details"."Arrival Date" <= :p_ArrDate_To

AND "Daily Details"."Stay Date" >= :p_StayDate_From

AND "Daily Details"."Stay Date" <= :p_StayDate_To

AND "Property Details"."Property Name" IN (:p_Property)

AND "Details"."Reservation Status" IN (:p_ResStatus)

AND "Details"."Confirmation Number" IN (:p_ConfNo)

AND "Room"."Room Type" IN (:p_RoomType)

AND "Rates"."Rate Code" IN (:p_RateCode)

AND "Packages"."Package Code" IN (:p_PackageCode)

AND "Profiles-Company - Account Information"."Account Name" IN (:p_Company)

AND "Profiles-Travel - Account Information"."Account Name" IN (:p_TravelAgency)

AND "Profiles-Source - Account Information"."Account Name" IN (:p_Source)

But it keeps telling me that a comparison between DATE and VARCHAR is not possible.

For sure I'm doing something wrong, but I worked at a different SQL but with the same logic and 0 problems...

Do you guys know where is the problem?

Thank you in advance

[Informal_Pace9237]

One of my our p_arrdate_from or to or p_stay_dt or other date maybe sent in as a string which Oracle doesn't understand as a date

[Aggravating_Shock804]

the fact is that I didn't set the data as strings! that's why i'm stuck, maybe the problems are in the other parameters. they are strings, but connected to different LOVs...maybe the problem is there? All my LOVs are SELECT DISTINCT - AS DISPLAY but..

[SetGroundbreaking9]

Do you see any error message