- This topic has 17 replies, 10 voices, and was last updated 19 years, 11 months ago by
.
-
Posts
-
Hi All,
I currently use Rapid SQL by Embarcadero to do database related work but I have just tired and really like the DBedit plug-in much better except it does not seem to support viewing or editing stored procedureds. Are there any plans to add this feature to DBedit or is there an alternative plugpin for eclipse that does this?
Thanks,
David.David,
Interesting request. I’m not really sure if we were moving that direction or not. You see, we basically target Java developers and most of those that I know (myself included) would simply hurt ourselves if we could write stored procedures. 🙂 Besides, is that part of the SQL standard or does each database vendor do something different?
I have to agree with David, being able to view/edit/create stored procedure packages would be a great feature. Going a step further, the ability to debug/test stored procedures would be even better. I was using JFaceDbc (which you can view packages) until it went commercial for Eclipse 3. I also tried using QuantumDB (again no ability to view packages). And I’m a Java developer working on a J2EE project where we have to write our own stored procedures. I’m not sure about the standards for stored procedures, but Oracle support would be great for me 😀 .
-Terrance
I was using JFaceDbc (which you can view packages)
If JFaceDBC supported package viewing, then the ME DB Explorer does as well (or should). The latter is based on SQLExplorer which in turn is derived from JFaceDBC. How does/did one access this info in JFaceDBC? Was this an oracle-specific extension? I know JFaceDBC uses so-called “plugins” (not eclipse plugins, but rather a “proprietary” mechanism) which we did not pull into the DB Explorer. If so, we can definitely explore further.
——————————————-
jeff
MyEclipse SupportYou can’t included oracle plugin – it is simple – You are include hibernate plugin and not editor extension and oracle
regards
Check out http://www.pratocity.com/index.jsp?mod=/jface/jfacedbc.jsp&mod2=oracle.jsp
JFaceDbc uses an oracle extension for viewing procedures, functions, etc…– Terrance
Hello,
oracle extensions don’t work with myeclipse – I try add jar file from sqlexplorer – Myeclipse change dababase view and it don’t work now
It work with sqlexplorer – sqlexplorer.dev.java.netregards
Yes, I perpetrated some serious refactoring of the sqlexplorer plugin for MyEclipse. It does not surprise me that it broke the oracle “plugin” … I have no oracle db to play with. The real target was the basic db exploring and hibernate support. I will enter this as an enhancement request in our issue tracker.
I realize this is an old topic, but I just wanted to add a vote for viewing of Stored Procedure / Package source. I haven’t tried JFaceDBC or SQLExplorer, but I’m currently annoyed with PL/SQL Developer and would love an in-Eclipse alternative.
Also, I don’t know how the SQLExplorer Oracle extension works, but it would be great if it used the DBA_SOURCE view for source viewing. I don’t know enough about Oracle to know what the alternatives are, but due to restrictive permissions established by our DBA team, I can’t see package body source in TOAD and can only see it in PL/SQL Developer when I choose the “Use DBA Views if available” option.
You see, we basically target Java developers and most of those that I know (myself included) would simply hurt ourselves if we could write stored procedures. 🙂
I couldn’t agree with you more -for a variety of reasons-.. And yes, I have worked with Oracle and stored procedures, including java stored procedures. (Oracle has a built-in jvm in the database.)
Having said that, I am in full sympathy with those that have to maintain systems that use them (and there are many out there), and being able to create/edit/deploy them from the ide, is very nice. (jDeveloper does this.) But as you said, this is not the base target for MyEclipse.
My $0.02.
-natOracle support is coming with 3.8.3 in early December. Will include stored proc creation and editing support, as well as support for creating and editing functions, packages, triggers, and much more.
@support-jeff wrote:
Oracle support is coming with 3.8.3 in early December. Will include stored proc creation and editing support, as well as support for creating and editing functions, packages, triggers, and much more.
View clobs?
