noticed that Robotask support oracle sql?

Discuss RoboTask here
Post Reply
helenharry
Posts: 1
Joined: Wed Jan 09, 2019 9:51 am

noticed that Robotask support oracle sql?

Post by helenharry »

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! :)
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: noticed that Robotask support oracle sql?

Post by Oleg »

Yes, RoboTask supports Oracle Database. But RoboTask uses Windows™ ADO engine to access data (not directly through native Oracle client).
The command SPOOL is not SQL command. Also your expression contains two commands: SPOOL and SELECT
It seems you want to export data from SQL query to CSV file.
You can write simple task to do this
Look at my simple example

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
DoNotStopWhenShutdown=INTEGER|0
ExternalName=STRING|"Task532"
Hide=INTEGER|0
ID=INTEGER|1591169541
LogOnAsUser=INTEGER|1
Name=STRING|"Write data to CSV"
OnErrorTaskID=INTEGER|-1
Priority=INTEGER|3
RunOnClose=INTEGER|0
RunOnStartup=INTEGER|0
ToLog=INTEGER|3
UnicodeFormat=INTEGER|1
WriteGeneralLog=INTEGER|0

[Actions]
Action1=FOLDER
Action2=FOLDER
Action3=FOLDER
Action4=FOLDER

[Actions\Action1]
ActionID=STRING|"A_VARIABLES_SET"
Enabled=INTEGER|-1
Name=STRING|"Set variable ""CSV_FILE"" with value ""C:\Users\VM\Desktop\QueryExport\data.csv"""
Params=FOLDER

[Actions\Action1\Params]
expand=STRING|"0"
varname=STRING|"CSV_FILE"
varvalue=STRING|"C:\Users\VM\Desktop\QueryExport\data.csv"

[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=scott;Data Source=Myserver;Persist Security Info=False;password=tiger"
override=STRING|"0"
paramcount=STRING|"0"
password=STRING|"1928821129195921933620110"
sql=STRING|"""select DEPTNO from DEPT"""
timeout=STRING|"60"
var2=STRING|"FIELDS"
withmemo=STRING|"0"

[Actions\Action3]
ActionID=STRING|"A_FILE_TEXTWRITE"
Enabled=INTEGER|-1
Name=STRING|"Create text file {CSV_file}"
Params=FOLDER

[Actions\Action3\Params]
encode=STRING|"0"
fileexists=STRING|"1"
filname=STRING|"{CSV_file}"
line0=STRING|"{Fields}"
linecount=STRING|"1"
suppress=STRING|"1"

[Actions\Action4]
ActionID=STRING|"A_LOOP_END"
Enabled=INTEGER|-1
Name=STRING|"End Loop"

Save the text of the task to a file and use menu Task->Import to import the task into RoboTask.
Oleg Yershov
Post Reply