Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Running multiple sql commands
Running multiple sql commands [message #44864] Tue, 03 June 2008 08:53 Go to next message
Eclipse UserFriend
Originally posted by: noah.drach.gmail.com

I'm using eclipse ee.

I have an SQL file containing several SQL commands.

If I mark the commands one by one and press alt+x they are executed fine
but when i try to execute the entire file I get 'ORA-00911: invalid
character'

my question is - is it possible to run the entire file similar to using
the @file.sql in sqlplus
Re: Running multiple sql commands [message #45421 is a reply to message #44864] Sat, 14 June 2008 21:27 Go to previous message
Emiel van Rooijen is currently offline Emiel van RooijenFriend
Messages: 4
Registered: July 2009
Junior Member
These commands are sent to the server directly through JDBC. The servers
are not aware of database specific client's ways of including files using
e.g. Oracle @file.sql notiation (sqlplus) or e.g. postgres's \i file.sql
(psql), etc. This is just the way JDBC works. It would be nice to have
something that allows this in DTP though, so I am considering proposing a
DTP specific mechanism that would allow this. But before doing so, this
must have been discussed before (I am replying, sorry for not digging into
the group some more...). Has this been discussed before or are there
enhancement requests in bugzilla? If not, is this something worth
considering?

Cheers,
Emiel van Rooijen
Re: Running multiple sql commands [message #591451 is a reply to message #44864] Sat, 14 June 2008 21:27 Go to previous message
Emiel van Rooijen is currently offline Emiel van RooijenFriend
Messages: 4
Registered: July 2009
Junior Member
These commands are sent to the server directly through JDBC. The servers
are not aware of database specific client's ways of including files using
e.g. Oracle @file.sql notiation (sqlplus) or e.g. postgres's \i file.sql
(psql), etc. This is just the way JDBC works. It would be nice to have
something that allows this in DTP though, so I am considering proposing a
DTP specific mechanism that would allow this. But before doing so, this
must have been discussed before (I am replying, sorry for not digging into
the group some more...). Has this been discussed before or are there
enhancement requests in bugzilla? If not, is this something worth
considering?

Cheers,
Emiel van Rooijen
Previous Topic:Execute SQL in the run toolbar button?
Next Topic:execution plan
Goto Forum:
  


Current Time: Fri Dec 19 15:17:07 GMT 2014

Powered by FUDForum. Page generated in 0.01980 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software