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.
Edited by moderator
2013-06-25T09:45:57Z
|
Reason: Not specified