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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PL/SQL Syntax Colors: PL/SQL Custom Syntax Rules Error

sect55Apr 27 2020 — edited Apr 28 2020

I upgraded 19.1 to 19.4 this morning.

I updated the PL/SQL Custom Syntax Rules but then I got the following error to next time I ran SQL Developer:

SQLDeveloperror20200427.JPG

The details follows:

java.lang.ClassCastException: oracle.javatools.editor.language.plsql.PLSQLLanguageSupport cannot be cast to oracle.dbtools.raptor.plsql.language.PLSQLLanguageSupport

at oracle.dbtools.raptor.config.SyntaxColorCustomOptions.initEditor(SyntaxColorCustomOptions.java:137)

at oracle.dbtools.raptor.config.SyntaxColorCustomOptions.<init>(SyntaxColorCustomOptions.java:63)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at java.lang.Class.newInstance(Class.java:442)

at javax.ide.util.MetaClass.newInstance(MetaClass.java:154)

at oracle.ide.javaxide.Util.createInstance(Util.java:62)

at oracle.ide.javaxide.Util.createInstance(Util.java:42)

at oracle.ide.extension.LazyClassAdapter.createInstance(LazyClassAdapter.java:65)

at oracle.ide.config.ExtensionSettingsPage.newTraversable(ExtensionSettingsPage.java:106)

at oracle.ide.config.ExtensionNavigable.newTraversable(ExtensionNavigable.java:87)

at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:219)

at oracle.ide.panels.MDDPanel.getTraversable(MDDPanel.java:1390)

at oracle.ide.panels.MDDPanel.access$800(MDDPanel.java:129)

at oracle.ide.panels.MDDPanel$Tsl.updateSelectedNavigable(MDDPanel.java:1653)

at oracle.ide.panels.MDDPanel$Tsl.updateSelection(MDDPanel.java:1561)

at oracle.ide.panels.MDDPanel$Tsl.actionPerformed(MDDPanel.java:1555)

at javax.swing.Timer.fireActionPerformed(Timer.java:313)

at javax.swing.Timer$DoPostEvent.run(Timer.java:245)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

at java.awt.EventQueue.access$500(EventQueue.java:97)

at java.awt.EventQueue$3.run(EventQueue.java:709)

at java.awt.EventQueue$3.run(EventQueue.java:703)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)

at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:190)

at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:235)

at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:233)

at java.security.AccessController.doPrivileged(Native Method)

at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:233)

at java.awt.Dialog.show(Dialog.java:1084)

at java.awt.Component.show(Component.java:1671)

at java.awt.Component.setVisible(Component.java:1623)

at java.awt.Window.setVisible(Window.java:1014)

at java.awt.Dialog.setVisible(Dialog.java:1005)

at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:399)

at oracle.bali.ewt.dialog.JEWTDialog.runDialog(JEWTDialog.java:360)

at oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:55)

at oracle.ide.panels.TDialogLauncher.showDialog(TDialogLauncher.java:225)

at oracle.ide.config.IdeSettings.showDialog(IdeSettings.java:875)

at oracle.ide.config.IdeSettings.showDialog(IdeSettings.java:612)

at oracle.dbtools.raptor.standalone.IndexedPreferencesCommand$IndexPreferencesTask.invokeLater(IndexedPreferencesCommand.java:219)

at oracle.dbtools.raptor.standalone.IndexedPreferencesCommand$IndexPreferencesTask$WaitOver$1.run(IndexedPreferencesCommand.java:231)

at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

at java.awt.EventQueue.access$500(EventQueue.java:97)

at java.awt.EventQueue$3.run(EventQueue.java:709)

at java.awt.EventQueue$3.run(EventQueue.java:703)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

How can I fix this or how can I revert it back to the default?

Windows 10

Oracle 11g Release 2

Robert

This post has been answered by Vadim Tropashko-Oracle on Apr 27 2020
Jump to Answer

Comments

Vadim Tropashko-Oracle
Answer

Reproduced, bugged, thank you.

To revert it back, delete custom_syntax.arbori.

Edit: To add custom styles, please follow instructions exactly, as described here. That is, start with default syntax highlighter rules, then add your additional rules, then save and quit sqldev. Edit your custom styles at the parent color options settings page.

Marked as Answer by sect55 · Sep 27 2020
sect55

where is custom_syntax.arbori located?

In the product preferences directory. On windows it would be something like

C:\Users\vadim\AppData\Roaming\SQL Developer\system19.4.0.351.1906\o.sqldeveloper

sect55

thank you. It worked!

1 - 4

Post Details

Added on Apr 27 2020
4 comments
621 views