Skip to Main Content

SQL Developer for VS Code

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!

Wishlist: Compiler should instantly abort when worksheet has obvious parser errors.

DataProcessingAug 9 2025

When you click the icon, compilation proceeds instantly. This is especially annoying when the worksheet contains thousands of lines of code that takes several seconds to print in the SCRIPT_OUTPUT panel.
if possible, please consider improving the user experience as suggested in the image comments,

Procedure P_PARSER_ERROR compiled
LINE/COL ERROR
--------- -------------------------------------------------------------
8/9 PLS-00103: Encountered the symbol "." when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json_object The symbol "<an identifier>" was substituted for "." to continue.

Errors: check compiler log

Comments
Post Details
Added on Aug 9 2025
1 comment
49 views