PL/SQL (MOSC)

MOSC Banner

Different result of select statement between sql*plus and run stored procedure

edited Nov 15, 2012 5:19AM in PL/SQL (MOSC) 9 commentsAnswered
Hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center