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.
- 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!
7,793 Comments
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
(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.
^Ignore that, that was meant to be posted as a general comment, not as a 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
I’m confused, is it xyz or ss for select * from?
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 “.
hello sir
It is worth to learn SQL in 2019 from scratch .I want to make a career in DBA.
You want to be a DBA, and you’re wondering if you should learn SQL?
Um….YES.
so sir can u guide me how i started …..
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.
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.
I’d definitely not hit the Delete button.
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…
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
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)
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.
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
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
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.
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?
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
are you using the custom proxy property for the connection, host:port ?
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.
Not sure why it wouldn’t work, I would just default back to using Putty
i cant create stopwatch in oracle forms how i can do this ?
Sorry, I don’t work with Forms.
Try asking here.
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?
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
There’s a few blog posts out there in addition to AWARD_BONUS() tutorial. There’s this as well, but I haven’t taken the course, so I can’t vouch for it.
Good article. I will be experiencing many of these issues as well..
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
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)
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!
If this is new for 19.2, same bug. A null date fubars the output going forward.
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
are you sure ORDS is running?
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
Java -jar ords.war standalone
If it’s running, you’ll see the process on the server
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.
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.
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?
Sounds like you have more than one Java home on your machine.
Edit the product.conf file to point to the newer one.
Is there a way to select columns of characters in the editor? For example, ALT-Mouse Drag in NPP.
Yes.
Nevermind. And really nice! Though I would like one click to select consecutive rows rather than multiple clicks.
https://www.thatjeffsmith.com/archive/2014/12/sql-developer-4-1-multi-cursor-editing/
it’s one click to toggle the mode, the rest can be done with your KB
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?
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.
Can you send me an example file?
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.
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!
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.
Here.
It is too long to be posted here though…
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).
The Excel issue is a bug, we’ll patch 19.2 soon to address/fix that.