Page 1 of 1
Oracle query error
Posted: Sun Mar 27, 2016 7:22 pm
by servio
Hi, I'm trialing this program and noticed that Robotask support oracle sql? my query for oracle doesn't seem to work:
spool C:\Users\VM\Desktop\QueryExport\data.csv
select DEPTNO from DEPT
1. Can someone please confirm if Robotask doesn't support Oracle SQL
2. What would be the appropriate way to write the query above?
Thank you in advanced!
Re: Oracle query error
Posted: Mon Mar 28, 2016 8:27 am
by Oleg
The command
spool C:\Users\VM\Desktop\QueryExport\data.csv
is not SQL command. This command is a command of Oracle SQL+
And it works
only in SQL+
Look at the example below how to write the data from query into CSV file.
Save the text of the task to a file and use menu Task->Import to import the task into RoboTask.
Of course, RoboTask can work with Oracle database.
Code: Select all
;*****************************
;* RoboTask Task file
;* Do not edit in text editor!
;*****************************
[Root]
ActionAfterRun=INTEGER|0
Actions=FOLDER
Automat=INTEGER|-1
CatID=INTEGER|444033236
Comment=STRINGLIST
ContinueOnError=INTEGER|0
ExternalName=STRING|"Task102"
Hide=INTEGER|0
ID=INTEGER|-528643301
LogOnAsUser=INTEGER|1
Name=STRING|"data to CSV (example only)"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
WriteGeneralLog=INTEGER|0
[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER
[Actions\Action1]
ActionID=STRING|"A_FILE_DELETE"
Enabled=INTEGER|-1
Name=STRING|"Delete File"
Params=FOLDER
[Actions\Action1\Params]
Count=STRING|"1"
deletedirs=STRING|"0"
file0=STRING|"C:\Users\VM\Desktop\QueryExport\data.csv"
hidden=STRING|"1"
subdir=STRING|"0"
system=STRING|"1"
ToRecycleBin=STRING|"0"
[Actions\Action2]
ActionID=STRING|"A_LOOP_DATASET"
Enabled=INTEGER|-1
Name=STRING|"Dataset Loop"
Params=FOLDER
[Actions\Action2\Params]
commatext=STRING|"0"
connectionstring=STRING|"Provider=MSDAORA.1;User ID=user;Data Source=MyServer;Persist Security Info=False"
override=STRING|"0"
paramcount=STRING|"0"
password=STRING|"1903220363208761908018826"
sql=STRING|"""select DEPTNO from DEPT"""
timeout=STRING|"60"
var2=STRING|"ROW"
withmemo=STRING|"0"
[Actions\Action3]
ActionID=STRING|"A_FILE_TEXTWRITE"
Enabled=INTEGER|-1
Name=STRING|"Create text file C:\Users\VM\Desktop\QueryExport\data.csv"
Params=FOLDER
[Actions\Action3\Params]
encode=STRING|"0"
fileexists=STRING|"1"
filname=STRING|"C:\Users\VM\Desktop\QueryExport\data.csv"
line0=STRING|"{row}"
linecount=STRING|"1"
suppress=STRING|"0"
[Actions\Action4]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"