[vdbdavid]

Hi there,

It’s new year so here is my most important wish-list-feature for 2005 😉

We work a lot with stored procedures (Oracle). The killer features for us would be a stored procedure editor with CVS integration …

[support-jeff]

Um, maybe I am just being dense here, but if you just saved the SQLEditor content with a stored proc, put it under CVS control, could you not just use all the standard eclipse team CVS tools? Are you looking for some special integration of CVS with the SQLEditor? Does not make much sense to me.

[vdbdavid]

Hmm, Jeff, I think you can move this topic to Database Tools.

I thought that the PL/SQL editor was not yet available in 3.8.3 … I do see the enhanced DB browser (with synonym, table, view, sequence, package, …) but when double clicking one of the packages in the “package” listing … nothing happens … I can’t see the source.
This works via TOAD so it’s not some kind of permission problem.
Clicking with the right mouse button results in a context sensitive menu with one entry: “copy name” …
In fact, all the other nodes (monitor, security, instance, function, procedure, trigger, …) behave the same.
The ERD modeler works fine 🙂

Any ideas?

Thanks in advance!

Conforming your Forum Posting Guidelines:

DB info: Oracle8i Enterprise Edition Release 8.1.7.4.0 – Production
With the Partitioning option
JServer Release 8.1.7.4.0 – Production
I’m connection via Oracle Thin Driver

What operating system and version are you running?
=> MS Windows 2000 5.00.2195 Service Pack 4
What Eclipse version and build id are you using? (Help > About Eclipse Platform)
=> Version: 3.0.1 – Build id: 200409161125
Was Eclipse freshly installed for MyEclipse?
=> It was for 3.8.2, for 3.8.3 I followed your update site.
If not, was it upgraded to its current version using the update manager?
=> I followed your update site.
Are any other external plugins installed?
=> Omondo UML (community edition)
How many plugins in the <eclipse>/plugins directory are like org.eclipse.pde.*
=> 14: org.eclipse.pde.build_3.0.0, org.eclipse.pde.build_3.0.1, org.eclipse.pde.core_3.0.0, org.eclipse.pde.core_3.0.1, org.eclipse.pde.doc.user_3.0.0, org.eclipse.pde.junit.runtime_3.0.0, org.eclipse.pde.runtime_3.0.0, org.eclipse.pde.runtime_3.0.1, org.eclipse.pde.source_3.0.0, org.eclipse.pde.source_3.0.1, org.eclipse.pde.ui_3.0.0, org.eclipse.pde.ui_3.0.1, org.eclipse.pde_3.0.0, org.eclipse.pde_3.0.1
What MyEclipse version are you using? (Help > About Eclipse Platform > Features)
=> Version: 3.0.1 – Build id: 200409161125
What JDK version are you using to run Eclipse? (java -version)
=> SDK1.4.2_02
What steps did you take that resulted in the issue?
=> see description above
Are there any exceptions in the Eclipse log file? (<workspace>/.metadata/.log)
=>
!ENTRY org.eclipse.webbrowser 2 0 Jan 10, 2005 16:26:36.947
!MESSAGE Internal browser is not operational
!STACK 0
org.eclipse.swt.SWTError: No more handles
at org.eclipse.swt.SWT.error(SWT.java:2717)
at org.eclipse.swt.SWT.error(SWT.java:2616)
at org.eclipse.swt.SWT.error(SWT.java:2587)
at org.eclipse.swt.browser.Browser.<init>(Browser.java:146)
at …

!ENTRY org.eclipse.webbrowser 1 0 Jan 10, 2005 16:26:36.957
!MESSAGE true/false

[support-jeff]

Nope, there is no ability to automatically edit PL/SQL in 3.8.3. The editor as it will exist just uses the same SQLEditor that is already in ME. However, my original comments still apply: save your PL/SQL in any editor you want, you wont get team/cvs specific behavior there; you get it by putting the file you created under source control and using the Team tools in eclipse.

[vdbdavid]

Indeed, that’s what we do right know: via TOAD we save de PL/SQL code to a local file and put that one in CVS (using TortoiseCVS).

So … my original feature request also still apply 🙂
=> It would be great that a tool like ME could do these steps for me:
1) get the latest version of a PL/SQL file from CVS or DB
2) edit the PL/SQL file
3) save it do DB and commit CVS in one go
=> CVS and DB are always in sync.

[NotesSensei]

Hi there,
I also would love to see support for PL/SQL (for the sake of MaxDb and Oracle) as well as IBM DB/2 SQL Procs.
First step would be load/save and syntax highlight
Second debugging.

If the (legal) context allows you could build on jsqleditor.org

🙂 stw

[Author]

Posts