A little food for thought

Wednesday, May 27, 2009

Notepad ++ and PLSQL

Recently I installed notepad ++ on my machine. As I am doing lot od javscript programming lately. And I found Notepad++ is one of the best editor for Javascript. Other being Visual Studio. But since I also do PLSQL programming I was looking for a way to get PLSQL Syntax checking and autocompletion. With some minor tweaking I could get both working. If you have similar requirement please follow these steps. 1>Create a file called plsql.xml in 'C:\Program Files\Notepad++\plugins\APIs' directory. 2> Copy and paste following code into this file.
 
 
    
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
        
    

3. Close and restart the notepad++. Enjoy

5 comments:

Johnny said...

i just tryed it, but not working.

Johnny said...

i just tryed it, but not working, is it caused by the newest version of the notepad++?

Roman Churakov said...
This comment has been removed by the author.
Roman Churakov said...
This comment has been removed by the author.
Roman Churakov said...

Characters <, & and > should be escaped. It should help.
Or, better yet,
1) Create a user-defined language using View\User-defined dialogue in Notepad++ GUI (just with any dummy values and settings).
2)userDefineLang.xml will be created automatically in %APPDATA%\Notepad++ directory.
3) Just edit userDefineLang.xml in accordance with the settings suggested by the author.

It worked in my case.