Ask A Question

Nearly 7,000,000 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!

7,513 Comments

  1. I have been happily running SQL Developer 18, able to connect to databases via connection_type = TNS with a full connect identifier string. SQLCL ‘just works’ with LDAP connections, no tweaking required.

    I upgraded to 19.2 and now both get the ominous ‘no ocijdbc18 in java.library.path’ error messages. I fixed the problem in SQL Developer by going to preferences .. databases .. advanced and putting in the paths to both the 12.2 thick client and the TNS_ADMIN directory. These did not need to be set in previous versions of SQL Developer, it ‘just worked’.

    SQLCL that was installed with SQL Developer is another story. I have set ORACLE_HOME and TNS_ADMIN in the windows 10 environment settings, no change. It connects via EZConnect or the jdbc connect string with no issues.

    I (foolishly) installed 19 in the same directory, so I can’t revert. I installed an old copy of 17.4 and it ‘just works’ (with the unpleasant addition of complaining about no log4j2 config file) – no tweaking of SQL Developer preferences, no tweaking of anything in SQLCL.

    C:\d\sqldeveloper\sqldeveloper\bin>sql idhere@mydbhere

    SQLcl: Release 17.4.0 Production on Tue Sep 03 12:07:14 2019

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

    Password? (**********?) ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging on
    **************
    Last Successful login time: Tue Sep 03 2019 12:07:20 -04:00

    Connected to:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management and Real Application Testing options

    SP2-0158: unknown COLUMN option “#”

    USERNAME INST_NAME HOST_NAME SID I_SERIAL VERSION
    ——————– ———— ————————- —– —————————————- ———-
    IDHERE mydbhere_1 mydbhostnamehere 348 762 12.1.0.2.0
    Enter value for _i_serial: 762

    SQL> exit

    — extracted 19.2 over where 17.4 was installed

    C:\d\sqldeveloper\sqldeveloper\bin>sql idhere@mydbhere

    SQLcl: Release 19.2.1 Production on Tue Sep 03 12:26:37 2019

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

    Password? (**********?) **************
    USER = idhere
    URL = jdbc:oracle:oci8:@mydbhere
    Error Message = no ocijdbc18 in java.library.path
    USER = idhere
    URL = jdbc:oracle:thin:@mydbhere
    Error Message = IO Error: could not resolve the connect identifier “mydbhere”
    USER = idhere
    URL = jdbc:oracle:oci8:@mydbhere
    Error Message = no ocijdbc18 in java.library.path
    USER = idhere
    URL = jdbc:oracle:thin:@mydbhere
    Error Message = IO Error: could not resolve the connect identifier “mydbhere”
    USER = idhere
    URL = jdbc:oracle:thin:@mydbhere:1521/mydbhere
    Error Message = IO Error: could not resolve the connect identifier “mydbhere:1521/mydbhere”
    Username? (RETRYING) (‘idhere/*********@mydbhere’?)

    C:\d\sqldeveloper\sqldeveloper\bin>echo %TNS_ADMIN%
    C:\app\client\product\12.2.0\client_1\network\admin

    C:\d\sqldeveloper\sqldeveloper\bin>echo %ORACLE_HOME%
    C:\app\client\product\12.2.0\client_1

    C:\d\sqldeveloper\sqldeveloper\bin>echo %JRE_HOME%
    C:\PROGRA~1\Java\JRE18~1.0_2

    • ayybates

      (Version 17.4.0.355)
      I just changed the colors around in the SQL Developer Editor, and the only thing I can’t figure out how to change is the block highlight color in the margin. (When you select an “if”, for example, it will show a bar on the left side of the window that goes down to the corresponding “end if”.) In the default scheme, it was a blue-grey color that contrasted with the white background, but now that I’ve changed the background to black, it’s a dark grey color that barely contrasts with the black. I figured out that under Display, I can toggle “margin indicates current block”, but I cannot figure out how to change the color of that indication to be more visible.

    • ayybates

      ^Ignore that, that was meant to be posted as a general comment, not as a reply

  2. Aussie_dan Reply

    Hi Jeff,

    When using code templates and autocomplete the ‘key’ value isn’t replaced so if, for example, I’ve defined “xyz=select * from ” and I type “ss” I can autocomplete but I end up with “xyzselect * from “. Any idea what might be going wrong here?

    Dan

    • Aussie_dan

      Rightly confused I’d say – my error.
      Should be:
      I’ve defined “xyz=select * from ” and I type “xyz” I can autocomplete but I end up with “xyzselect * from “.

  3. hello sir
    It is worth to learn SQL in 2019 from scratch .I want to make a career in DBA.

  4. Daniel Looby Reply

    Jeff,

    In SQL Developer 9.1 I clicked on File -> Open. Then in the dialog window I clicked on ‘Create New Subdirectory’. Worked great!. But how about the reverse: Delete Subdirectory. How does one accomplish that (i.e.: I added the same sub-directory twice and would like to get rid of the duplicate)?

    • Using the file open/save dialog? I would open my windows explorer or Finder to delete a directory.

    • Daniel Looby

      That’s great for local folders…perhaps. But when in the Open file panel on the left side are folders with a scroll bar. When I right click on the one folder it pops up the name (workday) and location (\\eisprod.nas.gatech.edu\dl23\workday… yes, it is a mapped network location). I don’t want to get rid of the actual folder/mapped network location with thousands of scripts. I just want to get rid of the folder on the left side of the dialog box.

    • Daniel Looby

      LOL. So then would you consider this a ‘bug’ that users can add folders in that left Location part of the dialog box…but can’t delete them?

      Also I would note that when I click on a local folder then ‘Location:’ changes and files are displayed underneath it. But sometimes when I click on the network location file nothing happens! So what good is being able to create a folder with a network location if a good part of the time it doesn’t work?

    • I don’t think people imagine using a dialog to open/save files to be used to delete files or directories.

      If you want to delete the directory, use your OS to do it.

      I’m guessing sometimes when you do something on the network folders, something is happening between sqldev/your machine and the network and machine on the other side of it…

    • Daniel Looby

      I’m not trying to harp on this, but I don’t think we are connecting on this, but in the ‘Open’ file dialog box issue. It appears I can’t send you a snapshot that illustrates what I am speaking of. Is there a means for me to do so?

      I have dropped the network location from my desktop. If I go into Word or IE to open a file the network location is no longer present. I closed SQL Developer and re-opened it. Still in the open dialog box the network location remains as a folder in the scroll box on the left side of the dialog box, above ‘Home’ with the picture of a small house, which is above ‘Desktop’ with a picture of a desktop blotter.

      Dan

    • you can send me a picture via a link and using an image service like imgur…but i know/understand what you’re saying now

      that list is a historical list of places you’ve browsed, it only shows so many…so go open/save a file from enough places that it gets pushed down the list

  5. Hi Jeff,

    I am getting below error immediately after getting connected to database. Any idea to resolve the issue or any kind of help will be really appreciated. I am struggleing to make it work for last one week but no luck.

    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. Hi

    I’m importing the following DDL into a model:

    CREATE TABLE DWH.dwh_action (
    action_name parameter_name NOT NULL,
    action_datetime general_date NULL,
    description description100 NULL
    )

    I’ve created the 3 domains manually (however, I expected them to be created automatically), but I still get the following message when importing for RDMS SQL Server 2012.

    <<<<>>>>
    Null domain occurred while creating dwh_action
    Null domain occurred while creating dwh_action
    Null domain occurred while creating dwh_action

    All 3 domains are not recognised. Any idea how I can fix this ? I have hundreds of tables to import, so assigning the data type manually is not an option.

  7. Ali Sheikh Reply

    Hi Jeff,
    I tried to add Notepadd++ as an external editor for SQL and PL/SQL but it’s invoking the notepad++ editor when I click on that. Is this a bug or I am missing something?.

    Thanks & Regards,
    Ali

  8. Hi

    Oracle SQL Developer Data Modeler

    I generated a DDL and my table columns make use of domain values. I’ve included the statements to create the domains in the DDL, however when importing, the domains are not automatically created.

    Is there any workaround to import the domains from DDL ?

    Regards
    Bilal

  9. Hi Jeff,

    I do have two separated designs from SQL Data Modeler and I have shared both entity and table from, lets say, DesignA to DesignB. It has worked well and everything is fine when it comes to share entities and tables among designs.
    My next step was to open the DesignB and create a relation between the shared entity (which belongs to DesignA) with a new entity from DesignB. Until here everything worked as expected and the logical ER diagram looks awesome. It is showing a shared entity and its relationship with a local entity (which belongs to DesignB) . Finally, yet in DesignB, when I performed the “Engineer to Relational Model” the new entity is transformed to a table, as expected, however the relationship with the shared table (which belongs to DesignA) was not created in the relational model, even though there is this same relationship defined at logical model between the shared entity (from DesignA) and the local entity (from DesignB). The same happened with the columns from the foreign key; the “Engineer to Relational Model” didn’t copy the attributes from the shared table to the relationship table.

    Jeff, am I doing something wrong? Is SQL DM able to transform to relational model correctly, whenever there are shared entity with established relationship with local entities?

    Thank you in advance for your attention.
    Anderson Bestteti

    • Hi Jeff,

      I’ve created a SR at MOS with regards to this issue. Here is the SR number for your records: 3-20856861331 : “Engineer to Relational Model” does not generate FK columns and constraints from shared table.

  10. I am running SQLDeveloper v19.1.0.994

    Noticed that sql using BREAK ON or COMPUTE SUM are not displaying properly in the query results window. Are these commands not supported in SQLDeveloper? Or does it only format correctly when spooling to a file?

  11. Hi Jeff,

    Remember me 😉
    I can’t connect through the proxy for cloud connections, even with “Proxy User” however on command line wget http://oracle.com works.
    Any suggestions?

    Duke

    • Sorry what do you mean with custom proxy property?

    • Yes, I am using custom proxy property, the error says
      Status: Failure – Test failed IO ERROR: the network adapter couldn’t establish a connection,
      my proxy requires authentication however with or without Proxy User info it doesn’t work.

  12. kerlos Abdallah Reply

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

  13. 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

    • 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?

  14. 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

  15. 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

    • 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

  16. 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)

  17. 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!

  18. 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

    • 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

    • 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.

    • Elie Grunhaus

      Thanks, Jeff.

      OK. I ran the ORDS validate command. Here are the results.

      Enter the name of the database server [localhost]:
      Enter the database listen port [1521]:
      Enter the database service name [db19]:
      Requires to login with administrator privileges to verify Oracle REST Data Services schema.

      Enter the administrator username:sys as sysdba
      Enter the database password for sys as sysdba:
      Confirm password:

      Retrieving information…

      Your database connection is to a CDB. ORDS will be validated in the CDB and PDBs.
      PDB PDB$SEED – validate ORDS 19.2.0.r1991647 (mode is READ ONLY, open for READ/WRITE)
      PDB PDB1 – validate ORDS 19.2.0.r1991647

      Enter 1 if you want to validate ORDS or 2 to exit [1]:

      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-21_230339_00120.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:06.492

      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-21_230345_00842.log
      Completed validating Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:04.235

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

      I then ran the command: Java -jar ords.war standalone

      This, in turn, threw the warning:

      WARNING: The pool named: |apex|rt| is invalid and will be ignored: The username or password for the connection pool named |apex|rt|, are invalid, expired, or the account is locked

      Honestly, I’m not sure what is happening. Would you know how to get around this?

      Thanks very much.

  19. 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?

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

  21. 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.

    • 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.

    • Mark Wright

      I finally have a current example.
      Using 19.2 sqldev. I am running a deploy script that deploys other code/scripts.

      Prompt ———-spec/pk_comm_posting.spc
      @schema/cmsuser/package/spec/pk_cmpsting.spc
      Prompt ———-body/pk_comm_posting.bdy
      @schema/cmsuser/package/body/pk_cmpsting.bdy

      As this calls the spc I then get

      ———-spec/pk_comm_posting.spc

      Error starting at line : 1 File @ C:\YoungLiving\Git\ylprd testpush\schema\cmsuser\package\spec\pk_comm_posting.spc
      In command –
      CREATE OR REPLACE PACKAGE cmsuser.pk_comm_posting IS
      Error report –
      Unknown Command

      Followed by many other errors that stem from this one.

  22. 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!

  23. 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?

    • 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.

  24. 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).

Reply To Mukesh Cancel Reply