Sample Header Ad - 728x90

DBeaver launch script from file

11 votes
2 answers
10149 views
I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances. I find ***DBeaver*** to be an interesting tool, it has a lot of great features, ***BUT*** it seems to lack an essential element: The possibility to launch scripts from the filesystem of the client machine in a batch-like way. For example, in SQL Developer I simply put a file called *delta_script.sql* that contains: @script1.sql @script2.sql @script3.sql I execute it as a script and the software executes all of the files in the correct order (provided that they are in the same directory as the delta_script.sql file). On DBeaver, this does not happen, instead I get a * **ORA-00900**: invalid SQL statement.*. How can I manage this to work as expected? I have tried the following in the delta_script.sql file with no luck: - @@ scriptN.sql - @/tmp/folder/scriptN.sql - @"/tmp/folder/scriptN.sql" - @"scriptN.sql" They're all giving the same error, so I think there's a problem with the "@". I have tried from SQLPlus with the synthax I use on SQL Developer without errors.
Asked by Samuryte (111 rep)
Mar 3, 2016, 12:56 PM
Last activity: Oct 1, 2024, 05:56 PM