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,998 Comments

  1. 403 Forbidden: The user can not access the ORDS Metadata database objects. Please consult the section in the ORDS documentation titled ‘Troubleshooting ORDS Metadata database objects access’.
    (I also cant find the documentation of ords anywhere except getting started, please also point me towards oracle documentation for ords)

    I have enabled ords authorization on a database schema and database table and getting the above error. Please guide me and am i missing anything

    I am running ords on tomcat.

    • thatjeffsmith

      It means you can’t access the metadata-catalog or OpenAPI endpoints on the schema w/o an authorized request – your authenticated user will need this role
      oracle.dbtools.role.autorest.YOURSCHEMA

  2. John Gallagher Reply

    Hi Jeff,

    We have a requirement to use Kerberos (sso) and LDAP (for role assignment).

    Environment: Linux | ORDS | Jetty (AD domain joined linux Server) talking to APEX 20 in 19c DB
    Users: Small number of AD users who will be doing light forms entry work.

    Struggling a little to find documentation, to vaidate that Kerberos can be integrated with Jetty and how to configure.

    Does the stack sound viable ? and would you have any pointers on SSO related config for this environment.

    NB – have found below link — does this advice still hold.?
    Should I ask this Jetty / Kerberos question via official support channels?

    https://community.oracle.com/tech/developers/discussion/4189524/how-to-use-ords-in-standalone-mode-with-kerberos-authentication

    Thanks,

    John

  3. Stephen OGorman Reply

    In SQL Developer 20.2.0, has SNIPPETS been removed.
    I am unable to open or Create a Snippet
    .Please advise ASAP.

  4. Recently switched from Weblogic to ORDS with Apache. Attempting to write a custom error html page to display the url with package and procedure name where the error occurred. Attempted to use jquery document.referrrer but when I get the result it is empty. I check Fiddler and there is no referrer returned and I would believe this is due to the setup with ORDS and Apache. Is there a way to get the referring URL back when we get a 4040 error?
    Thanks.

  5. Rohith Thomas Reply

    Hello Jeff:

    A simple (maybe rudimentary) question. Is it possible to setup a connect from SQL developer to the oracle SaaS layer (assume via BI)? I have tried searching high and low for some kind of tool set that allows us to query the FIN or HCM tables within SaaS from SQL Developer but haven’t had any success. I have seen 3rd party tools like claim to have done this (https://oraclecloudtools.com/how-to-connect-to-oracle-cloud-erp-database-using-sql-developer/) however i was wondering if this is something we could accomplish using an oracle product instead of 3rd party toolsets.

    • thatjeffsmith

      We’ll let you connect to anything you have database access for. If the SaaS offering gives you access to the database, then yes, you can connect. If it doesn’t, then you have to look at other possibilities. Several SaaS offerings have begun offering SQL Developer Web to give their subscribers access to their data in the Oracle Database – w/o giving access to the database itself.

  6. Scott Stegemann Reply

    I downloaded SQL Developer 20.2 and SQL Developer Data Modeler 20.3 for Mac OSX running Big Sur (11.0.1). Both say “JDK 8 or 11 required”. I downloaded and installed Java SE Development Kit 11.0.9. SQL Developer works (after bypassing Mac security to run an app not downloaded from the store), but I get an ‘Unsupported JDK version’ error pop-up which states “You are attempting to run with Java 11.0.9. Running this product is supported with a minimum Java version of 1.8.0_05 and a maximum version less than 1.9 …”

    I’ve then downloaded and installed JDK 8 and SQL Developer doesn’t start. I’ve searched for JAVA_HOME modification advice, uninstalled and reinstalled JDK 8, JDK 11, SQL Developer, and SQL Developer Data Modeler in various combinations and permutations over the last three days and I cannot find a configuration where I can get both products to run. Any advice?

    • Scott Stegemann

      I neglected to finish the sentence

      but I get an ‘Unsupported JDK version’ error pop-up which states “You are attempting to run with Java 11.0.9. Running this product is supported with a minimum Java version of 1.8.0_05 and a maximum version less than 1.9 …” when starting SQL Developer Data Modeler.

    • thatjeffsmith

      that dialog should also give you a button that lets you ignore that warning and run it anyway with java 11 – that’s fine

      the next version will have that fixed so it won’t warn you on the 11

    • Scott Stegemann

      Jeff,

      Thank you very much – that worked.

      I’ve tried ignoring that message in previous configuration attempts and I was getting a long list of modules that could not be loaded (see warning below) – must have been an issue with the JDK 8/11 combination that I had in place at the time. After ignoring the module warning, SQL Developer Data Modeler didn’t start.

      Thank you for your help and the very quick response. BTW – SQL Developer Data Modeler is a great tool – I’ve been using Oracle data modeling tools since Oracle Designer had to be run on a Sun Workstation.

      Warning – could not install some modules: org.eclipse.equinox.common – org.netbeans.InvalidException: Netigso: /Applications/OracleDataModeler.app/Contents/Resources/datamodeler/equinox/org.eclipse.equinox.common_3.6.0.v20100503.jar: Not found bundle:org.eclipse.equinox.common

  7. Hello Jeff:

    I use ver 19.2.1.247
    This just unexpectedly ocurred:
    With the navigator open I opened a package by double-clicking its node, but it opened in the same window as the Navigator, so that I couldn’t see the navigator tree and the code editor simultaneously. Until now, whenever I open a code editor it opens in a separate pane next to the Navigator, so that I can see both simultaneously, which is what I want.
    I can fix this by right-clicking and choosing “‘New Document Tab Group’”, but that doesn’t make the code editor automatically open that way the next time I open up another package. So how do I get it to do this automatically, as it did until today?
    Thanks very much for your help.

  8. Hi, I just upgraded and I tried to bring over the PL/SQL Syntax Colors I had set up in 18.4.0.376. There, I had an option to define a PlSqlCustom1 color for all of my custom named identifiers (as opposed to the Default Identifiers). This was very handy because the bright pink color I chose would only “pop” once my query code was correct. If I had an error, these particular identifiers would always show up as Default Identifiers. Very helpful for a novice!

    I don’t see an option to define PlSqlCustom1 in the newer version of Developer.

    I tried exporting my PL/SQL Custom Syntax Rules and then importing those in version 20.0.0.175. However, it doesn’t work. I also tried to read the articles referenced in the PL/SQL Custom Syntax window, but I couldn’t follow any of them. All were over my head. How can I bring over my custom named PL/SQL Syntax Color Scheme from version 18 to version 20?

    • Pencraft

      Yes, I was. And I said yes, and everything else came over*. I looked in the dtcache.xml file and saw in the section that the custom Scheme from my Version 18 installation is there. It’s just not showing up in the selection menu in the Tools>Preferences>Code Editor>PL/SQL Syntax Colors menu within Version 20. I also made a new scheme in Version 20 and saved it and this new scheme also shows up within the dtcache.xml file.

      At the next menu level down (PL/SQL Custom Syntax Rules) I can see this code:
      PlSqlCustom1: — The syntax highlighter expects a rule named “PlSqlCustomN”.
      [node) c_alias — Search all the nodes in the parse tree which are column aliases
      | [node) identifier — Or nodes with identifier payload,
      & [node-1) query_table_expression — which younger siblings are labeled with table names
      ->

      Which I thought would create ab identifier for me to modify in the prior menu level. But no. I don’t see the choice for plSqlCustom1 there.

      thanks so much for helping. Your information is awesome and the bits I understand are so very useful.

      *Thanks to you 🙂 I have some very handy templates set up and even a few special shortcut keystrokes. Thank you very much!!!! Those all made the migration to the new version with no issues.

Write A Comment