Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLDeveloper 4.0.2 generates wrong code for DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE

flaviocSep 8 2014

Hi,

I just found out that SQLDeveloper 4.0.2 generates wrong PL/SQL code when you edit a JOB.

In particular it seems it is mistaking the job argument position with the rownum of the query.

If you look at the following pictures, you see for instance that LATENCY having job argument position 6 and a value of 60 in the generated code would take a value of 240 and this value comes from rownum 6 in the first query.

Screen Shot 2014-09-08 at 11.54.19 AM.png

Screen Shot 2014-09-08 at 11.54.46 AM.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2014
Added on Sep 8 2014
0 comments
498 views