After this modification also its updating null values, please advice me guys


CREATE OR REPLACE PROCEDURE TEST_WEEK
AS
V_CREATE_DATE NUMBER;
V_SEQ_ID NUMBER;
CURSOR getcrsrww IS
SELECT CALCULATE_WEEK(TO_CHAR(CREATE_DATE,'DD-MON-YY HH:MI:SSXFFAM')) INTO V_CREATE_DATE FROM BIN_NOT
WHERE TIN_SEQ_ID =V_SEQ_ID;
BEGIN
OPEN getcrsrww;
fetch getcrsrww into V_CREATE_DATE;
UPDATE BIN_NOT SET TLC = V_CREATE_DATE;
close getcrsrww;
END TEST_WEEK;