Hi All,
I am trying to run a simple PLSQL block to print 100 output. When I run it executes successully on a normal session when connected
to database.
I tried submitting the same plsql query through scheduler job to run every min through SQL DEvELOPER .I can see the job
status as successful but when I select the job and in below section of SQL Developer I try to see the JOB_SCRIPT_OUTPUT
it shows an error : ORA-904 "OUTPUT" 'invalid identifier'
I am not sure why i am getting the error. Please guide me if I am doing anything wrong in here.
SET SERVEROUTPUT ON
DECLARE
X NUMBER := 100;
BEGIN
DBMS_OUTPUT.PUT_LINE(X);
END;
/