Running sql from a .sql file - VisualCron - Forum

Community forum

_steviec
2012-04-20T12:32:55Z
Hi,

Does anyone know a way to run a sql script file from a sql task? FYI, the database I connect to is Oracle 11 and the version of Visual Cron is 5.6.2.

I know that I can copy and paste the contents of the sql file into the Sql text query area of the task, and likewise, I know that I could copy the sql commands into a stored procedure. It's just that I would rather leave the sql on the file system (under version control) and I don't particularly want lots of stored procedures in the database. I realise that I could also run a sqlplus command but that doesn't seem ideal.

Many thanks in advance,

Steve.
Support
2012-04-30T12:33:50Z
If the folder is shared across the network you can use the File read Task and read the script and then use the output Variable for that Task in the SQL Text field.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
_steviec
2012-04-30T15:59:56Z
Thanks Henrik.

I tried that and unfortunately it doesn't work because the semi-colon terminator in Oracle isn't liked by the VisualCron ADO driver and therefore all the scripts would need to change. Therefore I think that stored procedures would be the best option.

Thanks again,

Steve.
Scroll to Top