HOME / Plugin Portal

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.

Plugin owner:	asumbatov
Website:	http://code.google.com/p/pl-sql-editor/
Added:	2008-08-02
Last updated:	2011-05-09
NetBeans Versions:	7.0
License:	GNU General Public License v2
Category:	Databases
Size:	1.05 MB
Downloaded:	13,861 times
Rating:	4.03, by 5 users

Verifications for NetBeans versions

Plugin is not subject to any verification

Introduction

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!

What's new in this version

Version 2.2 - 09 May 2011
Changes/Fixes:
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
Changes/Fixes:
Service release to support NetBeans 6.9 and JDK 6.

Version 2.0 - 10 May 2010
Changes/Fixes:
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
Changes/Fixes:
Issue 5 : Enter one-line summary
Issue 6 : Connecting with service name.

Version 1.1 - 5 December 2008
Changes/Fixes:
"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 11.1.0.7.0 (was 11.1.0.6.0)
New features:
All plug-in modules are signed now.

Version 1.0 - 2 August 2008
First release.

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

User Comments

UNABLE TO INSTALL PLUGINS FOR PL/SQL EN NETBEANS 7.0.1

i dowmload this zip and it have what i need but i could not instal pl/sql SOME HAVE THE SOLUTION FOR MY PROBLEM
1304942696_pl_sql-editor-bundle_2.2.zip
1251711190900_PLSQL_Editor_Plug-in_for_NetBeans_IDE.zip

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 >= 2.10.1.10.2 (release version 2) but only 3.9.1.13.10 (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

Thanks

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

Nice

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