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

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" ?