| Is DTP suitable for Oracle pl/sql development? [message #580997] |
Fri, 14 July 2006 19:30 |
Eclipse User |
|
|
|
Originally posted by: fburleigh.gmail.com
I've known of thee Eclipse project for quite a while but only now have I
let my curiosity--and need for a database development tool--lead me to
download the software on windows.
I got Eclipse 3.2 and the DTP that goes with it (from Help, Update).
After quite a struggle I discovered the concept of Perspective, then
defined an Oracle connection using an "oracle thin driver" (using the
class file for jre 1.4/5.0). I'm logged in to the 10gR2 database and
can see (some of) the schema. I see none of my Oracle packages or
procedures. It could be this tool isn't quite ready for this task for
Oracle yet?
I've not had much luck beyond that.
I made a "project," then a new sql file but can't see how to run any
sql. I'd expect to right click my open connection in the DSE then get
an sql editor open to that connection.
So I make a new SQL "Scrap book" and type some sql that I'd like to run
in the open connection I see in the DSE. I'm shown a kind of connection
editor that only offers me the ability to make a new connection, rather
than using the one I've already defined, shown in the DSE. The drop
down list "JDBC driver" only shows "other" (I have Oracle 10 selected in
the tree to the left). I can select a driver file but don't know what
to type in the JDBC driver class box or the connect URL box (I suspect I
could copy from the open connection in the DSE but that wouldn't help
with the class name box).
I can see a lot of work has gone in to this, and from the web pages it
seems that I should be able to debug my pl/sql. But maybe that's more
of a plan than a completed project?
Pointers much appreciated.
|
|
|
Powered by
FUDForum. Page generated in 0.03744 seconds
] 
Search
Help
Register
Login
Home
