Different result of select statement between sql*plus and run stored procedure
Just run the following statement on 'system' user directly on SQL*Plus, it has result (more than one row).
SELECT OWNER, JOB_NAME, LAST_START_DATE FROM ALL_SCHEDULER_JOBS A WHERE A.STATE='RUNNING';
But using as cursor in stored procedure, run the procedure on 'system' and it return nothing.
The 'system' user has DBA role. Don't know why.
Please help. Thank you in advance.
Raymond Zheng