Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009
    Posts
    34

    Unanswered: Stored Procedure

    I have a issue where i have to modify or update a stored procedure ans here are my conditions to update

    Fix DMS process to update Derived ODS table for LAST_SPONSOR_DATE and FIRST_SPONSOR_DATE
    --Our ETL calls a stored procedure DWSODS01.DWP11200_IMC_DMS_MAIN
    You will need to update the second merge statement into DWSODS01.DWT00102_DERV_IMC_MISC.
    FIRST_SPON_DT_KEY_NO = CASE WHEN (load.FIRST_SPON_DT_KEY_NO = 19000101 or (load.INMKT_FIRST_SPON_DT_KEY_NO is null)) then stg.INMKT_FIRST_SPON_DT_KEY_NO else load.FIRST_SPON_DT_KEY_NO END
    LAST_SPON_DT_KEY_NO = stg.INMKT_LAST_SPON_DT_KEY_NO

    I have kept the code in attachment.
    I made the required changes. I want someone to see the changed code and say whether it is right as i am new to oracle in total.
    I am also attaching the changed code( stored procedure tested in dev)

    Thank You.
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    some/many/most won't open up virus carrying *doc files.

    Expecting unpaid volunteers to debug large PL/SQL procedures, is not reasonable.

    Good Luck!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    Please post the relevant sections of code in a code block.

  4. #4
    Join Date
    Nov 2009
    Posts
    34
    Are the attached docs not opening?

  5. #5
    Join Date
    Aug 2009
    Posts
    262
    post this question at Ask Tom Home

    it will the best place for you to have your review .

    you will have to find a relavent thread to post this as a review .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •