-
simple procedure help needed
Folks,
I inherited this procedure which updates column TLC with our weeks generated from function calculate_week. I'm pretty dumb in PL/SQL so please help in making this procedure work as this is updating Null values into column. Our create_date column is of Timestamp with local timezone data type.-Oracle 9i rel2 on Nt
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
UPDATE BIN_NOT SET TLC = V_CREATE_DATE;
END TEST_WEEK;
Thanks
Last edited by portal; 03-21-2005 at 07:22 PM.
sat
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|