variable assignment error in stored procedure
833676Jan 29 2011 — edited Jan 29 2011i am writing this query giving me error
create or replace
PROCEDURE sp_AUDIT_ScrollAccepted
(
v_Date IN VARCHAR2 DEFAULT NULL ,
cv_1 IN OUT SYS_REFCURSOR
)
AS
BEGIN
IF v_Date IS NULL THEN
BEGIN
v_Date := to_CHAR(SYSDATE, 'DD/MM/YYYY') ;----------------error is coming in this line
END;
END IF;
error
Error(12,7): PLS-00363: expression 'V_DATE' cannot be used as an assignment target
what to do