| Running multiple sql commands [message #44864] |
Tue, 03 June 2008 04: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
|
|
|
| Re: Running multiple sql commands [message #45421 is a reply to message #44864] |
Sat, 14 June 2008 17:27  |
| Eclipse User |
|
|
|
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 17:27 |
| Eclipse User |
|
|
|
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
|
|
|
Powered by
FUDForum. Page generated in 0.16788 seconds
Home