ORA-00900: invalid SQL statement on VALID! SQL

[moberm]

Hi,

I get ORA-00900: invalid SQL statement on
select count(*)
from V$SESSION a,
dba_jobs_running b,
dba_jobs c
where a.SchemaName = user
and c.what= 'FORECAST_PROCESSOR.PROCESS_EVENTS;'
and b.job=c.job
and a.sid=b.sid

which should work w/o problems.
I have multiple sessions open and I run this query in a second session.
Any help appreciated,

Michael

 

[Marco Kalter]

This query runs just fine for me. Can you double-check the SQL.Text before you execute this, or use the Oracle Monitor to find out what exactly is being executed?

------------------
Marco Kalter
Allround Automations