Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    7

    Unanswered: pattern replacement

    Hi-
    How can I replace the pattern NULL by WSA_ROUTES_TRP_ROUTES_TIN1 .
    in the below statement.
    The word with which NULL need to be replaced should be extracted before a key word Exception


    Currently:
    BEGIN EXECUTE IMMEDIATE ' drop package WSA_ROUTES_TRP_ROUTES_TIN1 ' ; EXCEPTION WHEN OTHERS THEN NULL ; END ;


    Post replacement:

    BEGIN EXECUTE IMMEDIATE ' drop package WSA_ROUTES_TRP_ROUTES_TIN1 ' ; EXCEPTION WHEN OTHERS THEN WSA_ROUTES_TRP_ROUTES_TIN1 ; END ;


    Thanks in advance

    Kind Regards
    Pranab

  2. #2
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057
    Provided Answers: 1
    I don't quite understand your question.
    Do you want to edit multiple files and replace each occurance of "NULL", where it follows the word "EXCEPTION"? with the word that precedes the word "EXCEPTION" ?

Posting Permissions

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