PL/SQL (MOSC)

MOSC Banner

Cursor FOR LOOP goes into Exception

edited Feb 13, 2014 12:00PM in PL/SQL (MOSC) 2 commentsAnswered

Dear All

I have written a plsql program to create jobs in HRMS. When I execute this program LOOP is not executing it is directly goes into Exception. On printing SQLCODE and SQLERRM out is "-20001 ORA-20001: :". My cursor query is

SELECT TT.JOB_CODE,TT.JOB_DESCRIPTION,TT.STATUS,TT.ERROR

            FROM XXAASL_HR_JOB TT

            WHERE TT.STATUS IN ('N','R')

            ORDER BY TT.JOB_CODE

            FOR UPDATE OF TT.STATUS,TT.ERROR;

Kindly suggest what mistake i am doing.


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