DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: simple procedure help needed

Threaded View

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87

    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
  •  


Click Here to Expand Forum to Full Width