[Solved] Run two sentences in the same time in Oracle - VisualCron - Forum

Community forum

t2c_running
2013-02-28T15:59:10Z
Hi.

I would like to create a job with this two sentences:

ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SS";
SELECT * FROM SYS."LOGS";

but VisualCron only can run one query. If I enter in the SQL text query:

ALTER SESSION SET NLS_DATE_FORMAT = "DD/MM/YYYY HH24:MI:SS";
SELECT * FROM SYS."LOGS";

appears the error "Exception in Task: ORA-00911: invalid character"

Is there any solution to run this two sentences in the same task?

Thank you.
Support
2013-03-01T11:12:11Z
It is currently not possible but I am moving this to feature requests forum.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
t2c_running
2013-03-01T12:40:24Z
Support
2013-06-25T09:45:42Z
This has been fixed for version 7.0.0.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
t2c_running
2013-06-25T09:51:48Z
Thank you so much.

What provision is for releasing the version 7.0.0?
Scroll to Top