4.5+ million Oracle professionals use SQL Developer on a regular basis. Have a question about Oracle SQL Developer? Searched this blog and couldn’t find the answer? Ask away!
If your question is about Oracle Database, SQL, PL/SQL, etc – go Ask Tom!
Feel free to ask anything you want, but I’ll feel free to send you to Support or our Forums if it goes sideways.
Note: This page has turned out way more successful(?) than I would have ever imagined. Please keep these things in mind when asking questions.
- I am NOT support. Don’t expect me to log bugs for you, or give you official timelines on bug fixes, enhancements, or product releases.
- I AM NOT SUPPORT. Don’t open an SR with My Oracle Support AND leave a question here. Pick one and go with it, and when in doubt, go to My Oracle Support.
- I try to answer questions as quickly as possible. If you don’t get an answer, ask me for an update. I may have just forgotten or overlooked your request.
Go!
4,953 Comments
Hi Jeff …
Could you please help us with a question/dubt? we are executing a query through the sqlcl againt a database with NLS_LANG=WE8ISO8859P1 and we have the error : java.io.UnsupportedEncodingException: WE8ISO8859P1
Can we by pass this error or the sqlcl it’s not ready for all NLS_LANG existent
Hey Jeff – very informative blog!
Quick question though – is there a Go-to Column shortcut with SQL developer, similar to how we have Go-to Line(Ctrl + G)?
Thanks!
Sorry, but we don’t have that feature today.
Hi Jeff,
I am back to you to ask for feature I already asked in other threads and I apologize if I bother you but it is IMHO really important to use a separate (read only) connection for the SQLDev tasks. When one opens the “main” connection/session to a database that connection is used by SQLDev to fetch the metadata needed to show the database objects to the user. The same session may be tied to the editor and used to launch queries or compile packages. While a query tied to that session is in execution it is not possible, e.g., to open the tree containing the views in the chosen main session schema. All the sessions related to a particular connection should be not shared to avoid that the interactions between two editors tied to the same session will cause potentially evil outcomes.
Moreover it is really important to allow to tie a previously saved file to an unshared sessions.
BTW. The sql-plsql formatter still does not work well. I pointed out the problems the formatter has years ago (maybe in version 3), and , although improved since then, its behavior is still not good so that I sometimes go to sites like “instant sql formatter” to get a layout good enough to do plsql source code comparisons.
Examples please.
Hi Jeff,
I am using SQL Dev 19.1.0.094 and when I log on to a very busy Prod database and try & use Real Time SQL Monitor (We have diag + tuning packs), I constantly get “No content in table”. This would not be possible on our database as there has always been something to look at. This worked fine in previous versions of SQL Dev. Am I missing something?
Thanks
Vic
if you look at the Statements panel in the Log, you can see what queries we’re running to make that screen work
Jeff:
I use ver 17.3.1.279 and noticed that suddenly I can not see the window that contains the compiler log, which shows the compilation error messages. In the past I recall that if this happened I just clicked View – Log and it appeared, but that does not work now. I checked the Preferences, but can’t seem to find one that applies. Can you give me some suggestions please? Thank You.
that doesn’t usually appear until you actually have compiler errors/warnings
you’re on 17.3, you could try upgrading to 19.1, or using Window > Reset Windows to Factory Settings
I DO have compiler errors. I will try the upgrade. Thanks.
“Reset Windows to Factory Settings” worked!
Thanks.
I have SQL Developer 19, but I want to use the sdcli interface. Have the docs, but it is unclear how to define a connection so I can execute SQL. I see the connect syntax, which is like in SQL*Plus. I don’t have a Oracle Client install and from the docs it isn’t required. Not having luck with web searches either.
there are two command line interfaces, sqlcl and sdcli
you don’t use sdcli to execute queries, you use sqlcl
to get started, open a terminal/cmd window, and run the SQL exe or .sh and do something like, sql hr/[email protected]
then start using it just like you would with SQL*Plus
i have lots of videos, slides, blog posts, etc here in addition to the docs that should answer your questions
you don’t need an Oracle Cclient
I sincerely would like to have a web-meeting with Jeff Smith concerning configuring SQL Developer on Mac OS X.
You’re talking to me right now 🙂
Have you read this? What are your questions/concerns not covered there?
Hello,
I made an Rest-Call to receive max 150.000 records, but the answer is always limited to 10.000. Can i increase this limit somewhere ?
My call is:
http://xxxx/ords/a95/code?q={“$orderby”:{“fcode”:”ASC”}}&offset=0&limit=1500000
Thanks for help
Klaus
you need to make sure your module isn’t set to 10.000 but it’s more likely you have the max in your defaults.xml set to 10.000 – set it to 0 for unlimited
Thanks, now I’ve got it !
Can you please provide (if any) the shortcut to open a view and see the SQL.
I tried to use the SHIFT+F4 but it opens with no SQL tab.
I actually have to go to the view and click on it to see the SQL tab so I can view the code.
Thanks in advance
Candy
ctrl+click to ‘dive into’ the object and then you can see the SQL
or just use the DDL command
Hi
I am trying to install SQLDev 19.1 on Solaris 10. Is this possible? I get an error message when running sqldeveloper.sh
Could not find the main class: oracle.ide.osgi.boot.OracleIdeLauncher
I downloaded the Other platform release
The main requirement for Oracle SQL Developer is that you have access to a supported and working Oracle JDK 8 home on your machine.
First thing I would try is removing the folder, re-extract the Zip to a fresh directory, and try running it again.
Hello Jeff, Thank you for creating the website and instruction. I was wondering , I am trying to use the query builder with the HR DB when you mentioned to crap the tables for a drag and drop but when I am doing that nothing is populating in the worksheet. Possibly any ideas? Thank you for your time. I am appreciative.
>>when you mentioned to crap the tables for a drag and drop but when
I’m going to guess you meant to say, ‘grab the tables for a drag and drop’…and you mention query builder AND the worksheet, are you dropping into the worksheet, or into the query builder?
Either way you should be getting something. What exactly do you see when you do the drop? Any messages in the Log panel (errors)?
In TOAD, you could create a script in the correct order to create a table and indexes etc. Is there a function in SQL Developer that does all that? We’re moving people from TOAD to SQL Developer and the devs are complaining that the scripts aren’t working because they don’t create the table. Maybe we’re missing an option to include table creation in the script. The way they are doing it is going to the table, and clicking the SQL tab.
Hi Jeff,
More information:
TOAD for Oracle creates this script:
*** START OF TOAD SCRIPT ***
CREATE TABLE ADM_DD.DDMV_DOMAIN_ATTRIBUTE
(
DOMAIN_KEY NUMBER NOT NULL,
DWS_ATTRIBUTE_KEY NUMBER NOT NULL,
DOMAIN_NME VARCHAR2(100 BYTE) NOT NULL,
ATTRIBUTE_NME VARCHAR2(30 BYTE) NOT NULL
)
TABLESPACE DD_DATA_01
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_I1 ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE
(DWS_ATTRIBUTE_KEY)
LOGGING
TABLESPACE DD_INDX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE UNIQUE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_UI ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE
(DOMAIN_KEY, DWS_ATTRIBUTE_KEY)
LOGGING
TABLESPACE DD_INDX_01
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
CREATE OR REPLACE PUBLIC SYNONYM DDMV_DOMAIN_ATTRIBUTE FOR ADM_DD.DDMV_DOMAIN_ATTRIBUTE;
GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_DBA;
GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_DESIGN;
GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_FORM_ADMIN;
GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO DD_VIEW;
GRANT SELECT ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE TO PUBLIC;
*** END OF TOAD SCRIPT ***
Note that TOAD script has the create table first, then index creation after.
View the SQL Developer (latest version) script, visible from the SQL tab, or created via Create DDL right-click option:
*** START OF SQL DEVELOPER SCRIPT ***
— Unable to render TABLE DDL for object ADM_DD.DDMV_DOMAIN_ATTRIBUTE with DBMS_METADATA attempting internal generator.
CREATE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_I1 ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE (DWS_ATTRIBUTE_KEY ASC)
LOGGING
TABLESPACE DD_INDX_01
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 65536
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL
CREATE UNIQUE INDEX ADM_DD.DDMV_DOMAIN_ATTRIBUTE_UI ON ADM_DD.DDMV_DOMAIN_ATTRIBUTE (DOMAIN_KEY ASC, DWS_ATTRIBUTE_KEY ASC)
LOGGING
TABLESPACE DD_INDX_01
PCTFREE 10
INITRANS 2
STORAGE
(
INITIAL 65536
NEXT 65536
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLELCREATE TABLE ADM_DD.DDMV_DOMAIN_ATTRIBUTE
(
DOMAIN_KEY NUMBER NOT NULL
, DWS_ATTRIBUTE_KEY NUMBER NOT NULL
, DOMAIN_NME VARCHAR2(100 BYTE) NOT NULL
, ATTRIBUTE_NME VARCHAR2(30 BYTE) NOT NULL
)
LOGGING
TABLESPACE DD_DATA_01
PCTFREE 10
INITRANS 1
STORAGE
(
INITIAL 65536
NEXT 65536
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOCOMPRESS
NOPARALLEL
*** END OF SQL DEVELOPER SCRIPT ***
Note inthe SQL Developer-generated script, create index is the first entry in the script.
How do we get SQL Developer to create a script to create the table, then the indexes, so that SQL Developer can run the script without errors.
Note: that we are getting this error: — Unable to render TABLE DDL for object ADM_DD.DDMV_DOMAIN_ATTRIBUTE with DBMS_METADATA attempting internal generator.
TOAD doesn’t give any errors like that.. is SQL Developer more picky when it comes to permissions?
We also noticed that there is no space in “NOPARALLELCREATE TABLE ADM_DD.DDMV_DOMAIN_ATTRIBUTE”, which appears to be an error.
Thanks for your engagement with the community – it really does make a difference!
Toad doesn’t use dbms metadata to generate ddl, we do
You need fairly high privs for that package, check the DB docs for details
How the life of PL/SQL developer changes after the things start moving from on-premises to cloud? What are all tools we need and environment etc?
Thanks Jeff. Presumably Oracle uses DBMS metadata to generate DDL as that’s more reliable?
Yes, we’re asking the database for the DDL. So you get what the database says it is. Your tool has some queries that mine the data dictionary, and it builds the DDL from that.
Hi Jeff,
getting below on Sql Developer 19.1 when attempting to export query results/tables/user defined report results.
Is it occurring for you?
Thanks,
Peter.
java.lang.reflect.InvocationTargetException
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 oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)
at oracle.ide.wizard.Step.newTraversable(Step.java:171)
at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)
at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)
at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)
at oracle.ide.wizard.FSMWizard.(FSMWizard.java:121)
at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)
at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:73)
at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:168)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
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.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
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)
Caused by: java.lang.IllegalArgumentException: URI has an authority component
at java.io.File.(File.java:423)
at oracle.dbtools.raptor.ui.URLFileChooser.toFile(URLFileChooser.java:402)
at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1572)
at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1541)
at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1619)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:130)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:114)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:110)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:106)
at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.(URLFileChooser.java:862)
at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URLFileChooser.java:822)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:274)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:64)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:56)
at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.(ExportWizDestinstaionPanel.java:105)
… 54 more
java.lang.IllegalArgumentException: URI has an authority component
at java.io.File.(File.java:423)
at oracle.dbtools.raptor.ui.URLFileChooser.toFile(URLFileChooser.java:402)
at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1572)
at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1541)
at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1619)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:130)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:114)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:110)
at oracle.dbtools.raptor.ui.URLFileChooser.(URLFileChooser.java:106)
at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.(URLFileChooser.java:862)
at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URLFileChooser.java:822)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:274)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:64)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.(TargetOptionsPanel.java:56)
at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.(ExportWizDestinstaionPanel.java:105)
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 oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)
at oracle.ide.wizard.Step.newTraversable(Step.java:171)
at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)
at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)
at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)
at oracle.ide.wizard.FSMWizard.(FSMWizard.java:121)
at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)
at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:73)
at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:168)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:842)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
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.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
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)
Occurring when, after you click OK on the export dialog or before it even opens?
And no, this is working for me.
As soon as I click “Export…” the Export Wizard – Step 1 of 2 appears with Source/Destination highlighted on the left and “Internal Error when attempting to create this panel:” and Java log on the right.
do you have network drives mapped? that error says there’s a URL it’s finding and not liking
Hi Jeff,
got it fixed.
18.4 had “Use Oracle Client” not ticked but the field underneath was populated i.e. Oracle Home: file:/C:/……..etc as it doesn’t clear when Use Oracle Client is unticked.
Seems to cause an issue in migration to 19.1. When I tick “Use Oracle Client” in 18.4 and re-install 19.1 (migrating settings from 18.4) the export is now working!
Thanks,
Peter.
Hi Jeff,
I’m running sql developer with it’s included java.
sql datamodeler can be used pointing to the jdk folder in sql developer download.
I would like to run SQLcl in the same way because I’d like to avoid a full java installation as its shown on startup of SQLcl.
Is this possible? Yes? Please provide a short explanation.
Thx,
Dirk
is it possible to use SQLcl with the java
sqlcl doesn’t need a full jdk, just a JRE, so if your machine already had java 11 already, should be good
but to answer your question, yes. you just need to update the path on your machine to point to the jdk home in the sqldev folder, so your machine has access to it
that’ll open up your entire machine to Java programs though, not just SQLcl
Hi Jeff, I encounter issues with sqlcl and created discutions about that @Oracle Community.
How to be sure that the issues will be managed by development team ?
https://community.oracle.com/message/15342221#15342221
https://community.oracle.com/message/15348653#15348653
https://community.oracle.com/message/15348656#15348656
open Service Requests with My Oracle Support
our developers try to monitor the forums, but there’s no contract in place for us to treat the forums as an official support channel
i’ll go take a look at those threads though
Hi Jeff,
I’m using sql developer 4.2.0. I have set max char line width to 100. When I paste sql into editor with select line longer than 100 and click “Ctrl + F7” nothing is happening. I have On comma set to after. Can you help with formatting SQL?
When we install a new version of SQL Developer, we have to set locale to US, it should be Faroese, FO, otherwise we get an error message: Locale not recognized. Vendor code 17176.
Workaround is to set locale:
AddVMOption -Duser.language=en
AddVMOption -Duser.region=US
and that is not the best solution.
Is there any chance, it will be fixed?
Hello
I need to create a project for school with SQL developer but I’m only a beginner.
I have a part of my code but keep getting an error message which causes some tables to not be created.
This is my code:
CREATE TABLE speler(
spelerID INT CONSTRAINT speler_pk PRIMARY KEY,
ploegID INT NOT NULL,
spelernaam VARCHAR2(50 CHAR),
rugnummer INT,
positieID INT,
FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID),
FOREIGN KEY (positieID) REFERENCES positie(positieID)
);
CREATE TABLE spelerPositie(
positieID INT CONSTRAINT positie_pk PRIMARY KEY,
positie VARCHAR2(50 CHAR)
);
CREATE TABLE ploeg(
ploegID INT CONSTRAINT ploeg_pk PRIMARY KEY,
ploegnaam VARCHAR2(50 CHAR)
);
CREATE TABLE spelerWedstrijdspeler(
wedstrijdID INT NOT NULL,
spelerID INT NOT NULL,
FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
FOREIGN KEY (wedsrijdID) REFERENCES wedstrijd(wedstrijdID)
);
CREATE TABLE spelerWedstrijd(
wedstrijdID INT NOT NULL,
spelerID INT NOT NULL,
ploegID INT NOT NULL,
doelpunten INT,
FOREIGN KEY (wedstrijdID) REFERENCES wedstijd(wedstrijdID),
FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID)
);
CREATE TABLE wedstrijd(
wedstrijdID INT CONSTRAINT wedstrijd_pk PRIMARY KEY,
thuisploeg VARCHAR2(50 CHAR) NOT NULL,
uitploeg VARCHAR2(50 CHAR) NOT NULL,
competitieID INT NOT NULL,
wedstrijd_datum DATE NOT NULL,
wedstrijd_tijd TIMESTAMP NOT NULL,
FOREIGN KEY (competitieID) REFERENCES competitie(competitieID)
);
CREATE TABLE wedstijdCompetitie(
competitieID INT NOT NULL,
wedstrijdID INT NOT NULL,
FOREIGN KEY (competitieID) REFERENCES competitie(competitieID),
FOREIGN KEY (wedstrijdID) REFERENCES wedstrijd(wedstrijdID)
);
CREATE TABLE competitie(
competitieID INT CONSTRAINT competitie_pk PRIMARY KEY,
competitienaam VARCHAR2(50 CHAR)
);
And this or my errors:
Error starting at line : 2 in command –
CREATE TABLE speler(
spelerID INT CONSTRAINT speler_pk PRIMARY KEY,
ploegID INT NOT NULL,
spelernaam VARCHAR2(50 CHAR),
rugnummer INT,
positieID INT,
FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID),
FOREIGN KEY (positieID) REFERENCES positie(positieID)
)
Error report –
ORA-00942: table or view does not exist
00942. 00000 – “table or view does not exist”
*Cause:
*Action:
Error starting at line : 12 in command –
CREATE TABLE spelerPositie(
positieID INT CONSTRAINT positie_pk PRIMARY KEY,
positie VARCHAR2(50 CHAR)
)
Error report –
ORA-00955: name is already used by an existing object
00955. 00000 – “name is already used by an existing object”
*Cause:
*Action:
Error starting at line : 17 in command –
CREATE TABLE ploeg(
ploegID INT CONSTRAINT ploeg_pk PRIMARY KEY,
ploegnaam VARCHAR2(50 CHAR)
)
Error report –
ORA-00955: name is already used by an existing object
00955. 00000 – “name is already used by an existing object”
*Cause:
*Action:
Error starting at line : 22 in command –
CREATE TABLE spelerWedstrijdspeler(
wedstrijdID INT NOT NULL,
spelerID INT NOT NULL,
FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
FOREIGN KEY (wedsrijdID) REFERENCES wedstrijd(wedstrijdID)
)
Error report –
ORA-00904: “WEDSRIJDID”: invalid identifier
00904. 00000 – “%s: invalid identifier”
*Cause:
*Action:
Error starting at line : 29 in command –
CREATE TABLE spelerWedstrijd(
wedstrijdID INT NOT NULL,
spelerID INT NOT NULL,
ploegID INT NOT NULL,
doelpunten INT,
FOREIGN KEY (wedstrijdID) REFERENCES wedstijd(wedstrijdID),
FOREIGN KEY (spelerID) REFERENCES speler(spelerID),
FOREIGN KEY (ploegID) REFERENCES ploeg(ploegID)
)
Error report –
ORA-00942: table or view does not exist
00942. 00000 – “table or view does not exist”
*Cause:
*Action:
Error starting at line : 39 in command –
CREATE TABLE wedstrijd(
wedstrijdID INT CONSTRAINT wedstrijd_pk PRIMARY KEY,
thuisploeg VARCHAR2(50 CHAR) NOT NULL,
uitploeg VARCHAR2(50 CHAR) NOT NULL,
competitieID INT NOT NULL,
wedstrijd_datum DATE NOT NULL,
wedstrijd_tijd TIMESTAMP NOT NULL,
FOREIGN KEY (competitieID) REFERENCES competitie(competitieID)
)
Error report –
ORA-00955: name is already used by an existing object
00955. 00000 – “name is already used by an existing object”
*Cause:
*Action:
Error starting at line : 49 in command –
CREATE TABLE wedstijdCompetitie(
competitieID INT NOT NULL,
wedstrijdID INT NOT NULL,
FOREIGN KEY (competitieID) REFERENCES competitie(competitieID),
FOREIGN KEY (wedstrijdID) REFERENCES wedstrijd(wedstrijdID)
)
Error report –
ORA-00955: name is already used by an existing object
00955. 00000 – “name is already used by an existing object”
*Cause:
*Action:
Error starting at line : 56 in command –
CREATE TABLE competitie(
competitieID INT CONSTRAINT competitie_pk PRIMARY KEY,
competitienaam VARCHAR2(50 CHAR)
)
Error report –
ORA-00955: name is already used by an existing object
00955. 00000 – “name is already used by an existing object”
*Cause:
*Action:
Hopefully someone can help. Thank you.
I generally don’t have time to help with SQL or schema design questions, you should post this to StackOverflow, and hope your professor doesn’t mind.
I go into Excel, create a new spreadsheet and save the spreadsheet to my desktop. Then I go into Outlook, create a new email and when I click on ‘Attach File’ the newly created spreadsheet is at the top of ‘Recent Items’ and with one more click is attached to the email.
I write a query in a worksheet in SQL*Developer, get the results and then export the data in ‘excel 2003+ (.xlsx)’ format to my desktop. Then in Outlook I create a new email and click on ‘Attach File’. The newly created spreadsheet is not listed. I have to ‘Browse This PC’, click a location, maybe an additional sub-directory, find the file in the listing, click the file to get it in the ‘Open’ line and then click ‘Open’. Can the SQL*Developer Export option not add items to the same list that Microsoft uses to make the file selection less painful?
Dan
No, we can’t. We don’t have access to the windows/office APIs like a native msft app does.
What I do to avoid this pain, is i copy the filename (with) path while I’m in the Export dialog, so I can just paste it into explorer to open it, or attach to an email.
Jeff,
I also use a product name Snagit (from TechSmith) to get screen shots for articles and document things. When I take a snapshot of something and save it and then go into Outlook, open a new email and go to ‘Attach File’ there at the top of the list is the snapshot I took with Snagit. I can do the same with Notepad++, which is not a Microsoft product. So it would seem to be a generally available API for such.
those aren’t java applications, find me a java app that does that, and then i can go poke around to see how they did it
Hi Jeff,
Really appreciate the great content you publish in relation to the various products that you manage, thanks for this.
I’ve been looking into the possibility of automating the generation of pdf output from a SQL query. As a result, I was wondering if there was a way to use the SQLcl tool to run an User Defined Report (UDR) set up in SQL Developer to output results in a pdf format?
From reading some of your posts I believe it’s possible to format & export the output from an UDR within SQL Developer as pdf but was hoping to remove the manual intervention from this process, which is where I considered the SQLcl tool. It looks like the ALIAS option is available to easily define and run the source SQL from an UDR and i’m sure if i needed the output as CSV, JSON etc this would be ideal, but i’m unsure if this process could be used to output to pdf? Or is there a better way to do this type of thing using Oracle products (ORDS, APEX etc)?
Thanks,
Michael
I see it most when SQL Dev shuts down…abruptly.
This should fix it, Window > Reset to Factory
In the “other users” filter I want to include an underscore as a character in the filter. In sql i can do
LIKE ‘XX\_%’ ESCAPE ‘\’ to escape the _. How can I achieve the same in sqldeveloper filters?
I’ve not found a way to do this.
Hi Jeff,
In order to connect to the database, ORDS requires entry of the database’s hostname, port, and servicename or sid into the ords_params.properties file. This works fine, but does not comply with our enterprise standard of using OID (Oracle Internet Directory) to lookup the database connection details. For our applications that use the “thick” Oracle client, we have a SQLNET.ORA and LDAP.ORA file configured that points to our OID server. And for our Java applications, we use the JDBC “thin” Oracle client and just specify the JDBC connect string as follows:
jdbc:oracle:thin:@ldap://oid.company.com:3060/cn=OracleContext,dc=Company,dc=com/mydbservice
How can we make ORDS use a JDBC connection string?
Thanks,
Jack Wells
I’m still out on holidays, but lookup db.customURL in the ORDS Docs
Hi Jeff, I deployed ords.war with tomcat. I was testing the url (localhost:port/ords), and is success, but when I selected SQLWorkshop->RESTFulServices->Oracle.example.hr->empinfo->GET and Button TEST doesn’t appear.
I just validate ords.war and was success. The APEX_LISTENER , APEX_LISTENER_USER exists and are OPEN status.
Could you help me with that. Thanks
Regards
Jenny
Appreciate your site and have a question.
Just stepping into a new job and back into Oracle/Java arena. The team is diverse and though coding standards exist, timelines and deliverables have overridden a good portion of the codebase.
I want to write an “addin” to SQL Developer that enforces the coding standards (file naming, object format + name, etc) and integrate it to SQL Developer.
Can you point me in the right direction?
best place to get start is here