Update 1 table based on 2 other tables

UPDATE T1
SET T1.DATE_R = SYSDATE
WHERE T1.DATE_R IS NULL
AND T1.T2_ID IN ( SELECT T2.T2_ID
FROM T2,
T3
WHERE T2.T3_ID = T3.T3_ID
AND T3.CAN = 'N'
AND T1.DATE_P < (SYSDATE - T3.R_DAYS);
COMMIT; These two SQL statements works fine when executed. When I try to place them into a procedure, I get an error that says R_DAYS is not a valid column in table T3. HELP!
Thanks Received on Wed Jan 26 2005 - 17:06:48 CST