Ask A Question

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.

  1. 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.
  2. 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.
  3. 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!

5,158 Comments

  1. kerlos Abdallah Reply

    i cant create stopwatch in oracle forms how i can do this ?

  2. I download sqldeveloper 19.2 and sqlcl-19.2. I don’t have problem connect to database with my account using Kerberos authentication.in sqldeveloper. I also don’t have problems with sqlplus client 12.2. I have problem connect to the same database using sqlcl
    The error:
    ——————————-
    C:\sqlcl-19.2.1.206.1649\sqlcl>sql /@test
    SQLcl: Release 19.2.1 Production on Tue Aug 20 14:39:27 2019

    Copyright (c) 1982, 2019, Oracle. All rights reserved.

    USER =
    URL = jdbc:oracle:oci8:@(description=(address=(community=tcp.world)(protocol=tcp)(host=gggg)(port=1521))(connect_data=(sid=matl)))
    Error Message = no ocijdbc18 in java.library.path
    USER =
    URL = jdbc:oracle:thin:@(description=(address=(community=tcp.world)(protocol=tcp)(host=gggg)(port=1521))(connect_data=(sid=matl)))
    Error Message = ORA-01017: invalid username/password; logon denied
    Username? (RETRYING) (‘/@hou_matl’?)
    USER =
    URL = jdbc:oracle:oci8:@(description=(address=(community=tcp.world)(protocol=tcp)(host=gggg)(port=1521))(connect_data=(sid=matl)))
    Error Message = no ocijdbc18 in java.library.path
    USER =
    URL = jdbc:oracle:thin:@(description=(address=(community=tcp.world)(protocol=tcp)(host=gggg)(port=1521))(connect_data=(sid=matl)))
    Error Message = ORA-01017: invalid username/password; logon denied
    Username? (RETRYING) (‘/@hou_matl’?)
    USER =
    URL = jdbc:oracle:oci8:@(description=(address=(community=tcp.world)(protocol=tcp)(host=gggg)(port=1521))(connect_data=(sid=matl)))
    Error Message = no ocijdbc18 in java.library.path
    USER =
    URL = jdbc:oracle:thin:@(description=(address=(community=tcp.world)(protocol=tcp)(host=gggg)(port=1521))(connect_data=(sid=matl)))
    Error Message = ORA-01017: invalid username/password; logon denied
    ————–
    what is my problem?
    Thanks Mary

    • thatjeffsmith

      I’m guessing THIS
      Error Message = no ocijdbc18 in java.library.path

      How is your connection defined in SQL Developer?

      What Thick Client/Oracle Home do you have installed on your machine, if any?

  3. Paul Ryan Reply

    Hey Jeff, I saw your blog post on unit testing using sql developer. I’ve stepped through the examples (eg. AWARD_BONUS) mentioned in the Oracle documentation. I’ve searched youtube, etc. for examples with more detail (like explaining Test Implementations and use of “Seed/Create implementations using lookup values”) but am not having much luck. Are there more examples out there with greater detail? I guess the best course of action is to dive in and try some things but it can get frustrating.

    Thanks
    Paul

  4. Hi Jeff,

    I am using Windows 10 (64 Bit) and SQL Developer 19.1
    My sql files are associated with SQL Developer.

    When I click on an SQL file SQL Developer is opening and the file is shown in SQL Developer.
    When I click on another SQL file, a “working sign” is shown for a second and then nothing.
    The file is not opened.

    Dragging and dropping the file into SQL Developer worksheet is working, but that is a bit cumbersome.
    The problem was discussed in different forums, but no general solution was given.

    Do you have some magic to share?

    Kind regards
    Stefan

    • thatjeffsmith

      I have no magic to share…I think file>open or drag and drop is the way to go.

      I don’t know if this is a Windows/Java thing or something else

    • Hi Jeff,

      thank you for quick answer. Strange thing is, that there is no problem with other applications. If I associate SQL files with Notepad++ or Eclipse (also a Java application) files are opened like expected.

      Kind regards
      Stefan

  5. Hi Jeff,

    I am able to use and loving the SQLcl over SQL*plus. I was trying to put SQLcl in AWS for connecting to my oracle RDS. in one environment I am facing some weird issue. It connects to the database but when I try to type anything it gives java error and disconnets. No able to findout the issue.

    SQLcl: Release 19.2.1 Production on Mon Aug 19 21:28:25 2019

    Copyright (c) 1982, 2019, Oracle. All rights reserved.

    Last Successful login time: Mon Aug 19 2019 21:28:27 -07:00

    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
    With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

    SQL> Aug 19, 2019 9:28:29 PM oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli log
    SEVERE: null
    java.lang.NullPointerException
    at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.readLine(DbtoolsConsoleReader.java:2843)
    at oracle.dbtools.raptor.console.clone.DbtoolsConsoleReader.readLine(DbtoolsConsoleReader.java:2701)
    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1109)
    at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:492)

  6. Hello,

    I read in an earlier comment of an excel bug where the user only gets the header row when exporting from Linux and it will be patched. My issue between 19.1 and 19.2 is my query result is ~97K rows, but an export to xlsx is only sending the first 64K rows and stopping. Is that a bug, or is there now a setting I need to change somewhere to increase that — I definitely never had to alter any settings before for max rows to export.

    Thanks in advance!

  7. Elie Grunhaus Reply

    Hi Jeff.
    I have a question about using ORDS and the Jetty web server in combination with Apex 19.1 installed in a PDB container that is part of my Oracle 19.3 server installation on Windows 10 Home edition. Frankly, I’ve already posted this question on the Apex forum a few days ago but have not yet received any responses. And so, I thought to ask here of you.

    My environment:
    Windows 10 Home edition; Oracle server 19.3 multitenant (the CDB plus one PDB named pdb1); Google Chrome (latest version: 76.0.3809.100).

    Following the recommendation in this article (https://oracle-base.com/articles/12c/multitenant-uninstall-apex-from-the-cdb-12cr1#install-apex-in-pdb ), I first made sure that Apex was removed from my CDB by running the script apxremov.sql.

    I then connected to my PDB using ALTER SESSION SET CONTAINER=PDB1 and then ran the script apexins.sql to install Apex 19.1. All went well, no errors.

    I then installed ORDS 19.1 on the same PDB, making use of Oracle’s Jetty server. This allows me to install ORDS without having to install an application server like Oracle WebLogic or Apache Tomcat (reference this article: https://www.lkakarla.com/2018/12/apex-182-setup-on-windows-with-ords.html ). Again, no errors.

    However, after all was done, I tried to bring up Apex using this URL: http://localhost:8080/ords

    I was greeted with the error:

    This site can’t be reached
    localhost refused to connect.
    ERR_CONNECTION_REFUSED

    I have tried to adjust the security settings in Chrome to allow this URL. I have disabled Windows Firewall as well as my Kaspersky anti-virus software. All to no avail.

    Would you know how to get around this issue?

    Thank you for any help/advice/links.

    Elie

    • Elie Grunhaus

      Thanks for responding, Jeff.

      I ran the script: java -jar ords.war validate
      to validate my ORDS installation. It completed without error.

      Here’s the relevant output:

      Validating Oracle REST Data Services schema version 19.2.0.r1991647 in PDB$SEED
      … Log file written to C:\Users\egrun\ords_cdb_validate_core_PDB_SEED_2019-08-17_235524_00920.log
      Warning: Nashorn engine is planned to be removed from a future JDK release
      Completed validating Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:10.521

      Validating Oracle REST Data Services schema version 19.2.0.r1991647 in PDB1
      … Log file written to C:\Users\egrun\ords_cdb_validate_core_PDB1_2019-08-17_235535_00629.log
      Completed validating Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:05.123

      Completed CDB validation Oracle REST Data Services version 19.2.0.r1991647.
      Total Elapsed time: 00:00:16.388

      So, my take away from this output is that my ORDS installation completed OK.

      But I’m thinking that this does not confirm that ORDS is actually running.
      How can I do this?

      Also, I’m wondering if the Oracle Jetty stand-alone application server is my problem. How can I tell if Jetty is, in fact, running?

      Thanks very much.

      Elie

    • thatjeffsmith

      Java -jar ords.war standalone

      If it’s running, you’ll see the process on the server

    • Elie Grunhaus

      Hi Jeff.

      OK. I ran the following.

      java -jar ords.war standalone

      It showed me this message:
      SEVERE: The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked
      oracle.dbtools.url.mapping.TargetNotAvailableException: The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

      When I log into my PDB:

      SQL> select username,account_status from dba_users where username like ‘%APEX%’ or username like ‘FLOWS%’;

      USERNAME ACCOUNT_STATUS
      —————————— ——————————
      APEX_LISTENER OPEN
      APEX_PUBLIC_USER OPEN
      APEX_REST_PUBLIC_USER OPEN
      APEX_INSTANCE_ADMIN_USER OPEN
      APEX_190100 LOCKED
      FLOWS_FILES LOCKED

      6 rows selected.

      When I now run the URL: http://localhost:8080/ords/apex

      I get a page that says:

      503 Service Unavailable
      The username or password for the connection pool named |apex||, are invalid, expired, or the account is locked

      Any idea what this means?

      Thanks very much.

      Elie

    • thatjeffsmith

      the error is clear – the password you gave to the ORDS installer for APEX/and or ORDS_PUBLIC_USER is no longer the correct password, so ORDS can’t create those JDBC connection pools.

      Run
      java -jar ords.war validate

      It will prompt you for current passwords and set everything back to A-OK status.

  8. Hi, I have upgraded to SQL Developer 19.2 and I can no longer connect to the database using existing connections or new connections. I am running MacOS High Sierra 10.13.6. I get a message on startup of SQL Developer: “You are attempting to run with Java 1.8.0_77 … running this product is supported with a minimum Java version 1.8.0_121 …

    But, when I try to upgrade Java I get: “Your system has the recommended version of Java 8 update 221.”

    Any ideas how this can be resolved?

  9. Is there a way to select columns of characters in the editor? For example, ALT-Mouse Drag in NPP.

  10. Mark Wright Reply

    I’m a long time sql/developer user and have had this problem from time to time. I’ve narrowed it down to the fact that some editors will save a file with a BOM or byte order mark ( “”) and as a result will be unable to be run in sqldeveloper without removing same. Is there a way to have sqldeveloper ignore the BOM? or does that pose other problems that I don’t fully understand? It causes problems with script deployments where a master script is calling sub scripts from a deploy directory and those scripts may possibly have the BOM. The obvious answer is to force developers to remove the BOM themselves but is that really the right way to go about it? If there was a way for sqldev to ignore that it would be easiest for me, and that is always the answer I will choose first. Thanks for your efforts.

    • thatjeffsmith

      What happens when you open the file in SQL Developer and try to run it? What file encoding is in place for these files?

    • Mark Wright

      if it has trouble it will start with  and will not run from sqldev. Often this is from files that are saved in PLsql developer and I have to tell them to go to the BOM marker box and turn it off and resave.

  11. When I initially left a comment I seem to have clicked on the -Notify me when new comments are added- checkbox and
    now each time a comment is added I receive 4 emails with the same comment.
    There has to be a way you can remove me from that service?

    Many thanks!

  12. When making a new connection, the screen freezes, from there I will only be able to force quit the application. I am running version 19.2.0 (JVM 1.8.0_221) on Mac OS Mojave 10.14.6.
    Is there any solution for this?

    • thatjeffsmith

      Are you connecting or are you defining a connection?

      Either way, when it freezes/hangs, open a console/cmd window, and run this out of your jdk/bin directory

      Jstack -l ####

      Where #### is the process ID for SQLDev. Copy that output and post this to the Forums so we can take a look.

    • Where would be an appropriate place to post things like a stack dump?
      sorry I am very new to this.

    • It is too long to be posted here though…

  13. gone back to 19.1.. there are no noticeable improvements for me, and now when I try to export the resulting dataset from a query in xls(x) only the header row is produced (using openjdk 11 on linux).

Write A Comment