Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


frank_cal
2009-12-16T17:14:52Z
Hello,

I could I execute two query in the SQL TEXT Query ?

An example :

DELETE FROM SERVICE_LEVEL a
WHERE a.CALENDAR_DAY in
(select distinct B.CALENDAR_DAY from SERVICE_LEVEL_UPLOAD B);


insert into SERVICE_LEVEL (select * from SERVICE_LEVEL_UPLOAD);

I get an error ORA-00911....

The database in Oracle.

Thanks
Sponsor
Forum information
Support
2009-12-16T19:35:03Z
No, because we retrieve output from each query and handle parameters separately. Please create two SQL Tasks.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top