PROCEDURE SP_SEARCH_ORDERS(
O_RESULT OUT SYS_REFCURSOR,
P_ORDERDATE DATE,
P_USER VARCHAR2,
P_ORDERSTATUS VARCHAR2,
P_PAYMENTSTATUS VARCHAR2
)
AS
STMT VARCHAR2(4000);
BEGIN
STMT := 'SELECT * FROM TBL_ORDERS ODR JOIN TBL_ORDERBILLING_SHIPPING ODRBILLSHIP WHERE';
IF P_ORDERDATE IS NOT NULL THEN
STMT := STMT || ' and ODR.ORDER_DATE like ''%' || P_ORDERDATE || '%''';
END IF;
IF P_USER IS NOT NULL THEN
STMT := STMT || ' and ODRBILLSHIP.S_FNAME like ''%' || P_USER || '%''';
END IF;
IF P_ORDERSTATUS IS NOT NULL THEN
STMT := STMT || ' and ODR.ORDER_STATUS like ''%' || P_ORDERSTATUS || '%''';
END IF;
IF P_PAYMENTSTATUS IS NOT NULL THEN
STMT := STMT || ' and ODR.PAYMENT_STATUS like ''%' || P_PAYMENTSTATUS || '%''';
END IF;
EXECUTE IMMEDIATE STMT;
-- DBMS_OUTPUT.PUT_LINE(STMT);
END SP_SEARCH_ORDERS;
how to execute string query ,its giving error that missing keyword.
any help appreciated,