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!

SQL Developer (4.2.0.17.089) worksheet silently fails if comment line begins with "@"

pachyanJun 14 2017 — edited Jul 15 2017

This is a BUG report.

I was surprised to discover in the latest version of SQL Developer a silent failure which could have led to dire consequences for what I was doing...

When running a script (create or replace package) in a worksheet in SQL Developer, we noticed that nothing at all happens if any comment line begins with @.

If there's any character before the @ it's fine, such as a *.

Example of a silent failure:

create or replace package MYPACKAGE AS

/* NAME: somefunction

PURPOSE: do something

AUTHOR: me

@param x some integer

@return some varchar2

*/

FUNCTION SOMEFUNCTION(x in integer) RETURN VARCHAR2; ...

Sometimes we have a * before the @param, so it's fine in that case. When running multiple files at once, some are silently passed over. This does not happen in SQL Developer 4.1.5.

Can someone enter a bug or direct me to a page where I submit bugs? Or does this count?

Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2017
Added on Jun 14 2017
6 comments
391 views