Eclipse Community Forums: DTP » Running multiple sql commands

Help

Home

Home » Eclipse Projects » DTP » Running multiple sql commands

Show: Today's Messages :: Show Polls :: Message Navigator

Running multiple sql commands [message #44864]

Tue, 03 June 2008 08:53

Eclipse User

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

Report message to a moderator

Re: Running multiple sql commands [message #45421 is a reply to message #44864]

Sat, 14 June 2008 21:27

Emiel van Rooijen

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

Report message to a moderator