I am using SQL Developer version 4.1.0.17 to access an Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production instance.
I have found this issue in both the Early adopter version and the general release version of SQL Developer (4.0.3.16)
I have created a DBMS_SCHEDULER job which executes a PLSQL procedure which in turn uses DBMS_OUTPUT to write out some messages.
When I execute the procedure interactively, it writes out the messages as I expected.
When I run the job, it completes successfully, and executes the procedure.
When I look in SQL Developer at the Job's Run Log, I can see the log information for each run.
When I select a specific run, it shows up successfully in the Job Run Details display.
When I select the JOB SCRIPT OUTPUT tab however, I get the following error message:
ORA-00904: "OUTPUT": invalid identifier
00904, 00000 - "%s: invalid identifier"
*Cause:
*Action:
Vendor code 904
Why am I getting this error? Is there a parameter I need to set?
Any help would be gratefully appreciated.