PL/SQL Editor - plugin detail

This plugin will add support for editing Oracle PL/SQL objects right inside the NetBeans IDE, including syntax highlighting, code folding and indentation.

NetBeans Plugin - PL/SQL Editor
Plugin owner: asumbatov
Added: 2008-08-02
License: GNU General Public License v2
Category: Databases
Downloaded: 21,851 times
 4.03, by 5 users

Plugin Log Show log

Versions available

Download plugin   Download size: 1.05 MB   Last Update: 2011-05-09

What's new in this version

Version 2.2 - 09 May 2011
Support NetBeans 7.0
Actions Compile and CompileLocalFile done in threads
Fixing toggle-comment functionality
GUI. Migrate org.jdesktop.layout.GroupLayout -> javax.swing.GroupLayout
Issue 7 : Compile Local File does not recognise some syntax
Issue 8 : Does not work with netbeans 7beta2
Issue 9 : Not recognized statements
Issue 10 : When character { and } is included in a string or comment compile fails

Version 2.1 - 22 June 2010
Service release to support NetBeans 6.9 and JDK 6.

Version 2.0 - 10 May 2010
The PL/SQL language support is migrated from Generic Languages Framework (Project Schliemann) to Lexer & Parsing & Indexing API.
Required NetBeans 6.8 or newer.
Requirement about 500MB Java heap memory free is obsolete.

Version 1.2 - 4 March 2010
Issue 5 : Enter one-line summary
Issue 6 : Connecting with service name.

Version 1.1 - 5 December 2008
"Oracle Connection" form - layout problem fixed.
No more questions where locally save PL/SQL objects but still possible to change in the objects property form. Default folder is the user’s document directory.
Issue 3 : PL/SQL editor does not support JOIN expressions
Bundled Oracle JDBC driver is upgraded to version (was
New features:
All plug-in modules are signed now.

Version 1.0 - 2 August 2008
First release.

Verifications for NetBeans versions

Plugin is not subject to any verification


The aim of PL/SQL Editor is to provide a convenient way to work with the following Oracle objects inside IDE:
  • Functions
  • Procedures
  • Packages Specification
  • Packages Body
  • Types Specification
  • Types Body
  • Triggers

With each object you could perform the following operations:
  • Add - create a new object
  • Edit - edit the object source code
  • Compile - compile the server-side object
  • Compile Local File - compile the object from the local file
  • Delete - drop the object

It's also possible Refresh (reload) nodes and discovers Properties. The unique feature of PL/SQL Editor is the PL/SQL language syntax recognition. This means that PL/SQL code will be parsed during code typing or loading and syntactically checked. This gives possibility to correct code before compiling. The PL/SQL Editor also supports code folding, code navigation and other features.

For more details including installation and documentation please check the project home page.

Thank you!

[ You have to be logged in to be able to comment. ]

User Comments


Installing in NetBeans 8.0.1

Installed without troubles on Fedora 64 bits.
Hope Formatting will be avalible someday.
Posted by javatlacati on Jan 13, 2015

sql*plus plugin

I need plugin for SQL*PLUS editor in netbeans 7.0.1. Where would I get it ?
Posted by rk_ti on Mar 25, 2013


i dowmload this zip and it have what i need but i could not instal pl/sql SOME HAVE THE SOLUTION FOR MY PROBLEM
Posted by horion1983 on Dec 26, 2011

Unable to install plugin / Problem installing this plugin

Please, check the requirements/compatibility matrix on plugin website. If you're still having problems contact me via email. Thanks.
Posted by asumbatov on Sep 07, 2011

Unable to install plugin

Whenever I try to install the plugin in 7.0.1 I get the following error:

The plugin Editor Library is requested in version >= (release version 2) but only (of release version different from 2) was found.
Posted by gchristiansen on Sep 06, 2011

Problem installing this plug in

Again and again getting error msg
Anyone help please.
Thanks in advance
Posted by sanjivoak on Aug 14, 2011

Installing in NetBeans 6.5.x

Unlike "lriera" I was able to install the PL/SQL plugin into Netbeans 6.5. First I got error messages, too. After setting "-J-Xmx"-Parameter in "netbeans.conf" no more problems occured.
Posted by abollm on Aug 24, 2009

Please make this plugin support other DBs too

I'd like to see this plugin turned into something that also supports Postgres, MySQL, MSSQL, etc.
Posted by rdelaplante on Feb 22, 2009


No more TOAD.....
Posted by andressdl on Nov 12, 2008

Installing in Netbeans 6.5

I was not able to install the PL/SQL pluging into Netbeans 6.5.
Posted by lriera on Nov 02, 2008


This is nice. At least the Oracle connections wont bug me as much as they did before. And nice syntax highlighter too :-)
Posted by arthurbuliva on Oct 22, 2008

Excelent editor

Greatest plugin it works perfectly and help me a lot with mi work. The most i like about this plugin is the syntax recognition and the compiler. excelent work.
Posted by rmoron on Oct 21, 2008
By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo