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. Is there any documentation on what privileges are required to use the “Monitor Sessions” feature of SQL Developer? Is there a standard role that includes these? Thanks.

  2. Keith Bines Reply

    Applying same schema filters across multiple database connections. How can I define a schema filter in other user and have that be applied to multiple database connections rather than just one. This would be akin to the “favourite schema” functionality in toad

  3. Keith Bines Reply

    is there a quick way of switching current schema other then running alter session set current schema. The drop down in toad to do this is very useful

  4. Peter Cunningham Reply

    Hi Jeff,
    getting some very slow response times in Sql Developer 18.3 using the SQL tab for a table.
    Looks like we have up to date dictionary stats in place. Some SQL I can see running below. Any suggestions for speeding it up?
    Thanks,
    Peter.

    SELECT /*+all_rows*/ VALUE(KU$), 0
    FROM SYS.KU$_OBJGRANT_VIEW KU$
    WHERE NOT BITAND(KU$.BASE_OBJ.FLAGS,128)!=0
    AND KU$.BASE_OBJ.NAME=”
    AND KU$.BASE_OBJ.OWNER_NAME=”;

    SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$),
    XMLFORMAT.createFormat2(‘TABLE_T’, ‘7’)),
    KU$.OBJ_NUM
    FROM SYS.KU$_HTABLE_VIEW KU$
    WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192)
    AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0
    AND KU$.SCHEMA_OBJ.NAME=:NAME1
    AND KU$.SCHEMA_OBJ.OWNER_NAME=:SCHEMA2

    • That doesn’t look like our code…I’m out of the office today, but our code makes calls to dbms metadata to generate the SQL behind a table.

    • Peter Cunningham

      Thanks for getting back Jeff.
      The SQL above is probably originating from within dbms_metadata so.
      90sec+ response time on the SQL tab.

    • Ok, so you’re looking at recursive SQL on a session trace.

      DBMS_METADATA is usually ‘slow’ on the first call or 3, and then should have about a 1-2 sec response time on subsequent calls. If you are seeing things differently, I’d open a SR with MOS – but don’t file it on SQL Developer, file it with the general DB, and share the underlying DBMS_ calls that SQL Developer is just happening to be making.

      This is after you’re confirmed your data dictionary stats are indeed up to date.

  5. Jack Wells Reply

    Hi Jeff,

    There’s an annoying behavior of SQL Developer’s with LDAP connections. It seems to caches the TNS settings after you’ve loaded them from the LDAP (OID) server. Then, if the database (a PDB) gets moved to another container CDB located on a physically different server, SQL Developer won’t connect without me first going into the connection dialog, and clicking on the “Load” button next to the “DB Service” field. I guess that refreshes the local cache.

    Is there a way to prevent this value from being cached? I’d like the connection, when defined with LDAP methog, to query the TNS setting *every* time I connect.

    Thanks!
    Jack

    • I doubt we’d ever imagine thise entries would be so volatile.

      How often it’s this happening?

    • Jack Wells

      It happens fairly frequently… we move PDBs around a lot. In any case, all of our other clients (sqlplus, jdbc, Toad, etc) don’t exhibit this behavior. If the OID setting for a database changes, the client should always know about it. Think of the OID setting as a IP address in a DNS server… it should be “permanently cached” in the client as that defeats the whole purpose of having a centralized location for these settings. Do you agree?

      Thanks,
      Jack

  6. Wayne Clarke Reply

    How do I configure ORDS to not include the items{} wrapper around the return data?

    • Answer #1 – you don’t. We have a standard here at Oracle for how {JSON} docs are constructed, and this is part of our spec.

      Answer #2 – you generate your own {JSON} and make your handler of type MEDIA RESOURCE, and we won’t touch it…in other words we’ll return the raw output you provide.

    • Does this only work if you are on 12c or higher? I’m on 11g.

    • So…. We do not use Apex and I agree with you that we should. The company I work for is moving to 12c over the next few weeks. We you suggest that we would be better served by waiting until after the upgrade in order to utilize the native JSON features included?

    • A couple of weeks will be here before you know it…once it’s here, you’ll have about a half dozen ways to generate JSON.

      What’s wrong with the item wrapper? Any decent JSON parser should be able to work around that.

      I mention this because if you go the ‘raw’ route – you lose the automatic paging and url filtering features built into ORDS for query results, etc.

  7. Hi Jeff,
    I am a teacher in high school. My students are struggling with data modeler .Is there any video tutorial for them to view and understand

    • Quite a few – from various different sources.

      I haven’t done much in terms of video for the modeler, but I have a ton of blog posts here

      Is there a specific area they are having problems?

      How many students? I’d be happy to do a webinar for your class! Just email me at [email protected]

  8. We’ve run into a problem that simple queries against rather large tables (100’s of GB) in oracle sql developer can runaway and cause database issues. E.g. we had one today, e.g. select * from warehouse.xyz, which has DOP=16, that someone ran just to look at a few rows from the table, then forgot about it. But later we had numerous production jobs fail due to lack of temp ts, and checking in session monitoring we could see it still out there using 1.4TB of temp and 76 threads, for just that one simple query. I’m not sure if it’s a bug or if there is some setting we need to tweak to avoid this. Other SQL query tools used across the team do not experience this same behavior. We would appreciate any tips or advice you could offer on this. Thanks!

    • your users need to know if they leave a query ‘open’ – that is, not having fetched all the records – they are leaving those processes out there

      the best way to avoid this is with resource consumer groups and a plan that will prevent them from taking more resources than you want them to have

      of course, if they would grab all the data they want or close those grids when they’re done looking at them, it would avoid the pain you are seeing

  9. Hey there Jeff and other members here,

    I’m trying out ORDS for a new RESTful API setup for work.

    We have a remote Oracle Database that has ORDS enabled on it but no application server to handle the requests so we can’t use it yet, but I wanted to try it out locally on my computer using SQL Developer and went to “Tools” => “REST Data Services” => “Run”

    And start the standalone that is included with SQL Developer.
    I create a Demo module and Template and added a GET Handler to it and select from dual just to test.

    But when I load the page in my browser I get: “404 – The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured”

    The database connection it self in SQL Developer works fine I can do everything from there.

    The Scheme I am trying to use has Rest Services enabled
    I go to localhost/ords/:scheme/:model/:template

    Does the remote database I am connecting to have to have a application server running in order to use it locally from SQL Developer or am I missing something?

    Hope I’m making some sense here and you understand me 😀

    • ORDS has it’s own webserver, it’s called Jetty – and that’s what you’re seeing when you get the 404

      so a GET on localhost:port/ords/:schema/demo/:template should work, unless your pattern was actually /demo/:template/

      You rest enabled the schema, yes? What did you set for the alias? It defaults to the schema name, but that’s what you have to use for :schema in your URI

      Also, as a test, you can just hit
      localhost:port/ords/schema/metadata-catalog/

      that will bring back a list of modules for your rest enabled schema

    • Thank you for the response,

      Yeah its REST enabled, its alias is “test”

      So to see all modules it should be
      localhost:8080/ords/test/metadata-catalog/
      right?
      If I do that I still get “The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured”
      So I feel like I am missing something, like my Jetty is not getting a connection to my DB but I can’t seem to find anything that tells ORDS to use my current connection to the remote database I am using.

    • stop ORDS in your copy of SQLDev

      download ords from oracle.com/rest

      extract the zip on your desktop

      go to a cmd prompt,
      java -jar ords.war

      point it to a config directory

      walk the wizard, it’ll start ords up and run it on your db

      then try to hit the GET

    • Hey Jeff,

      I tried that but I still get the same erorr, “404 The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured”

      The database does not have to be on the same machine as the Jetty Server is?

      I mean my database is on a remote machine and I am trying to run this on my local machine,
      I have the Ords_public_user passwords but always when I give it up it also ask for sys as sysBA to verify REST Data Services schema but I don’t have that, is that needed to set this up localy?

      Ords is active on database

    • But as I understand from my Oracle System administrator ORDS is installed on the Database Server and the ORDS_PUBLIC_USER does exist, why do I need the SYS password to connect the local Server to the ORDS on the Database server?

      Am I misunderstanding how this works, I was under the impression that the Jetty server I was setting up on my local machine was just a version of a HTTP server that answers my uri’s on my local network and routes them to the ORDS on my remote database server.

    • your oracle system admin will need to do the install

      once that happens, the ORACLE_PUBLIC_USER will be able to PROXY CONNECT to ANY rest enabled schema in the database – that’s no small thing, and that’s why we require SYS AS SYSDBA level access to set it up

    • My Oracle Admin has already installed ORDS on the Database,
      So the question is how can I run my Jetty Server locally by just connecting to the database which is on another machione, and not install anything?

      “java -jar ords.war standalone” been running this.
      Do I need to add some parameters to this or add something to the ords_params.properties file?

      and please let me know if I’m misunderstanding this drastically :S

      When I run the above command this is t he output

      2018-11-27 16:01:28.900:INFO::main: Logging initialized @1103ms to org.eclipse.jetty.util.log.StdErrLog
      Nov 27, 2018 4:01:28 PM
      INFO: HTTP and HTTP/2 cleartext listening on port: 8888
      Nov 27, 2018 4:01:29 PM
      INFO: Disabling document root because the specified folder does not exist: /home/{user}/ORDS/ords/standalone/doc_root
      2018-11-27 16:01:29.206:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_181-8u181-b13-0ubuntu0.16.04.1-b13
      2018-11-27 16:01:29.245:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
      2018-11-27 16:01:29.245:INFO:oejs.session:main: No SessionScavenger set, using defaults
      2018-11-27 16:01:29.246:INFO:oejs.session:main: node0 Scavenging every 600000ms
      Nov 27, 2018 4:01:29 PM
      INFO: No pools configured yet
      Nov 27, 2018 4:01:29 PM
      INFO: Oracle REST Data Services initialized
      Oracle REST Data Services version : 18.3.0.r2701456
      Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT

      2018-11-27 16:01:29.436:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@5ae9a829{/ords,null,AVAILABLE}
      2018-11-27 16:01:29.446:INFO:oejs.AbstractConnector:main: Started ServerConnector@74650e52{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8888}
      2018-11-27 16:01:29.446:INFO:oejs.Server:main: Started @1650ms

    • run the installer, point it to that db, give it the right password for the ords public user account, and you’re good to go

      if we can’t validate the setup, it’ll want to do the install over again and then you’ll need the SYS account

      Jeffreys-Mini:ords thatjeffsmith$ java -jar ords.war
      This Oracle REST Data Services instance has not yet been configured.
      Please complete the following prompts
       
      Enter the location to store configuration data:/ords/config
      Enter the name of the database server [localhost]:
      Enter the database listen port [1521]:
      Enter 1 to specify the database service name, or 2 to specify the database SID [1]:1
      Enter the database service name:orcl
      Enter the database password for ORDS_PUBLIC_USER:
      Confirm password:
       
      Retrieving information.
      Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.
      If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]:2
      Nov 27, 2018 11:20:45 AM  
      INFO: reloaded pools: []
      Nov 27, 2018 11:20:45 AM oracle.dbtools.rt.config.setup.SchemaSetup install
      INFO: Oracle REST Data Services schema version 18.3.0.r2701456 is installed.
      Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
      Enter 1 if using HTTP or 2 if using HTTPS [1]:1
      2018-11-27 11:20:57.839:INFO::main: Logging initialized @71640ms to org.eclipse.jetty.util.log.StdErrLog
      Nov 27, 2018 11:20:57 AM  
      INFO: HTTP and HTTP/2 cleartext listening on port: 8080
      Nov 27, 2018 11:20:57 AM  
      INFO: Disabling document root because the specified folder does not exist: /ords/config/ords/standalone/doc_root
      2018-11-27 11:20:58.227:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_191-b12
      2018-11-27 11:20:58.266:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0
      2018-11-27 11:20:58.266:INFO:oejs.session:main: No SessionScavenger set, using defaults
      2018-11-27 11:20:58.267:INFO:oejs.session:main: node0 Scavenging every 600000ms
      Nov 27, 2018 11:20:58 AM  
      INFO: Creating Pool:|apex|pu|
      Nov 27, 2018 11:20:58 AM  
      INFO: Configuration properties for: |apex|pu|
      db.hostname=localhost
      db.password=******
      db.port=1521
      db.servicename=orcl
      db.username=ORDS_PUBLIC_USER
      resource.templates.enabled=true
       
      Nov 27, 2018 11:20:58 AM  
      WARNING: *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***
      Nov 27, 2018 11:20:58 AM  
      WARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***
      Nov 27, 2018 11:20:58 AM  
      INFO: Oracle REST Data Services initialized
      Oracle REST Data Services version : 18.3.0.r2701456
      Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT
       
      2018-11-27 11:20:58.534:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@8b96fde{/ords,null,AVAILABLE}
      2018-11-27 11:20:58.547:INFO:oejs.AbstractConnector:main: Started ServerConnector@1f0f1111{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}
      2018-11-27 11:20:58.547:INFO:oejs.Server:main: Started @72348ms
    • Thanks, I have been running this and I get this error in the console:
      “Retrieving information.
      Requires SYS AS SYSDBA to verify Oracle REST Data Services schema.”

      So I guess I just have to have the SYS user information to be able to verify the setup or is there something I can get the Oracle admin to change to I don’t need the SYS privileges to validate just to install?

  10. On an export of a query to Excel… The filename should be a drop-down… Same for doing an import from Excel

  11. Hi Jeff
    Thanks for maintaining a fabulous site.
    Is it possible to get SQL*Developer to remember last used settings in “working session”?
    * Last used export settings?
    * Last used open folder?
    * Last used save folder?
    * etc.?

    • Instead of doing a MRU on an export, you can set the defaults in the preferences.

      Most of the file and directory dialogs should have a drop-down control that show the MRU items.

    • Hi Jeff
      I know we can set the defaults for export options, however some users would like MRU.
      I fail in finding your MRU drop-downs in file/directory dialogs in windows8. Could you be a bit more specific?

  12. Jeff, is it correct that:
    1) all ORDS *_DEFINE APIs could be executed *only* under user whos schema was enabled by “enable_schema call?”
    2) user who executes ORDS *_DEFINE APIs will own objects created by that calls (modules, templates etc)?

    If yes, what is recommended approach for DevOps users – how to create all ORDS objects in right place (for example in HR schema) if we have to use special DevOps database user for deploying all our database objects to production?

    One option could be to create stored procedure under target HR schema containing all ORDS *_Define calls:

    Create procedure HR.ORDS_DEFINES as …
    BEGIN
    ORDS.define_module(
    p_module_name => ‘testmodule2’,
    p_base_path => ‘testmodule2/’,
    p_items_per_page => 0);

    ORDS.define_template(
    p_module_name => ‘testmodule2′,
    p_pattern => ’emp/’);

    ORDS.define_handler(
    p_module_name => ‘testmodule2′,
    p_pattern => ’emp/’,
    p_method => ‘GET’,
    p_source_type => ORDS.source_type_collection_feed,
    p_source => ‘SELECT * FROM emp’,
    p_items_per_page => 0);

    COMMIT;
    END;
    /

    – then:
    1) create that procedure under DevOps user – it will be created in target schema HR
    2) run that procedure under DevOps user – it will be run with owner righs as if HR runned it, so we will have ORDS objects created on behalf of HR

    Or is there a better way?
    Thanks!

    • your special devOps user will need to alter session set current schema before making the ORDS package calls to deploy the services

  13. I mean, run ORDS.Create_module and enable_schema(‘not_current_schema_name’) for example. Also in create_handler we use objects from different schema.

    When we try to run it, it says “insufficient priv-s”.

    If i can’t make it clear tomorrow will type an example

  14. Hi Jeff, please answer: what privilegies are required for user so he is able to create ORDS objects in different schema (in all schemas?)

    are there some special grants or smth? from what user should this grants be run?

  15. Hi Jeff,
    With respect to the twit I sent you on Nov 19th 8:25PM , you replied to send you an example to look.
    Instead of using twitter I thought this would be a better way to show the weird behaviour with 18.3 (I updated to latest version).

    I am just reporting to you. I did not mean to call you on twitter for Tech Support. I apologize if that came across like that. I sincerely just wanted to share with you. I do read your posts and follow you. Thank you for the great work you’re doing. We all benefit from it!

    Anyway, here’s the script I ran and the output:

    create table names(fname varchar2(20),Notes varchar2(255));
    insert into names (fname,Notes) values (‘Fabián’,’Esta es una teoría’);
    insert into names (fname,Notes) values (‘Ramón’,’Es una buena canción’);
    insert into names (fname,Notes) values (‘Charles’,’great show’);
    insert into names (fname,Notes) values (‘Ulíses’,’es un espectáculo’);
    commit;

    select * from names;

    select /*insert*/ * from names;

    Output:

    Table NAMES created.

    1 row inserted.

    1 row inserted.

    1 row inserted.

    1 row inserted.

    Commit complete.

    FNAME NOTES
    ——————– —————————————————————————————————————————————————————————————————————————————————————
    Fabián Esta es una teoría
    Ramón Es una buena canción
    Charles great show
    Ulíses es un espectáculo

    REM INSERTING into NAMES
    SET DEFINE OFF;
    Insert into NAMES (FNAME,NOTES) values (‘Fabián’,’Esta es una teoría’);
    Insert into NAMES (FNAME,NOTES) values (‘Ramón’,’Es una buena canción’);
    Insert into NAMES (FNAME,NOTES) values (‘Charles’,’great show’);
    Insert into NAMES (FNAME,NOTES) values (‘Ulíses’,’es un espectáculo’);

    • My output in 18.3 with application encoding (set in first page of Preferences) to UTF-8

      TABLE NAMES created.
       
       
      1 ROW inserted.
       
       
      1 ROW inserted.
       
       
      1 ROW inserted.
       
       
      1 ROW inserted.
       
       
      Commit complete.
       
      FNAME     NOTES                  
      Fabián    Esta es una teoría     
      Ramón     Es una buena canción   
      Charles   great SHOW             
      Ulíses    es un espectáculo      
       
       
      REM INSERTING INTO NAMES
      SET DEFINE OFF;
      INSERT INTO NAMES (FNAME,NOTES) VALUES ('Fabián','Esta es una teoría');
      INSERT INTO NAMES (FNAME,NOTES) VALUES ('Ramón','Es una buena canción');
      INSERT INTO NAMES (FNAME,NOTES) VALUES ('Charles','great show');
      INSERT INTO NAMES (FNAME,NOTES) VALUES ('Ulíses','es un espectáculo');
  16. Is it possible in SQL dev 18.3 or 18.4 to search for a particular database from a list of databases (shown at top right corner in sql worksheet) on which I want to run my custom report? The list is not ordered in any form so it is difficult to scroll list of hundreds of databases to pick one. Some time this list is sorted alphabetically (of connected databases) but this is not always the case. Is there a workaround for this please or can it be added into future releases?

    • There is an order…it lists CONNECTED connections first, and then the rest are in alphabetical.

      They are searchable via the keyboard, you can type in the name of your connection.

      You can also open a worksheet from the connection tree.

    • No they are not keyboard searchable, there is only a drop down list and I have to scroll to find out my required database. Also these are not ordered by alphabetically (of connected databases). I don’t want to open a worksheet but I want to run the report.
      I am in the report window, and when I click on a report, by default the report is displayed for the chosen database but I want to run the same report on another database and to do that I have to scroll the whole list of connected and non-connected databases to find my desired one.

    • I just tried it…i have a connection named ‘HR’ and it took me right to it when I started typing.

    • Ok, you said you were in a worksheet, but you’re in the reports window. I’ll look again this morning.

  17. Hi, Jeff. Thanks a lot for all these posts.
    But I have a trouble, which solution I couldn’t find.

    We have a working ORDS service. we did ENABLE_SCEMA(p_schema=>’DEMO’, p_url_mapping_type=>’BASE_PATH’, …);

    after we defined all the modules and templates all worked, and the URL was like dev.our.dev-site:8080/ords/DEMO/our_module/our_template/ for GET.

    Now we need to have all these things in another schema, ESK. we tried do define it like DEMO: ENABLE_SCEMA(p_schema=>’ESK’, p_url_mapping_type=>’BASE_PATH’, …); and create modules and templates all the same as in DEMO schema but with names esk_module, esk_template.

    but URL dev.our.dev-site:8080/ords/ESK/esk_module/esk_template/ returns error 500. Maybe we do smth wrong? how make ORDS look into schema ESK? should we disable DEMO first?

    • 500 means probably something in SQL is bad

      Check the ords standard out for the ORA’s, which should point you in the right direction. I talk about this here.

      You can also turn on in ords print errors to screen and debug .. but don’t ever do this for prod.

    • is it better than 404? that means, it found my pool with all these things, but can’t run it properly?

      (Excuse my poor English)

  18. Hi Jeff!
    Thank you for your videos on using Reports in SQL Developer, watched them just two months ago and I can not create reports fast enough. This is a feature I have been in search of for a long time. I had adopted SQL Developer years ago and it had glitches which frustrated me and resulted in it being ignored for many years.
    I have created a lot of “User Defined Reports” and have found a couple of issues, which I am hoping you can tell me you are aware of these issues and/or Oracle Support is working on them. If you are not aware of these issues, I can write up an SR with Oracle Support to have the issues addressed.
    1. When a new report or folder is added, the tree of folders will expand all of its reports; That is, other folders and sub-trees expand out, so I have to find where I was working again and fold in any expanded folders;
    2. When the number of folders and reports extend beyond the bottom of the screen, the “Reports” window forces scrolling of the reports up, therefore, not able to select a report until it is done scrolling. Many times, the folders above must be collapsed to be able to work on reports located lower in the window.

  19. Hi Jeff, I’m using SQL Developer Data Modeler (Version 18.3.0.277 build 277.2354) to create a logical data model. How does one visually indicate which entity attributes form an entity to entity relationship? For example, consider entity ‘parent’ that has a single attribute ‘id’ that is also the primary key for that entity. In addition consider another entity ‘child’ that has two attributes, ‘id’ and ‘parent_id’ the former being the primary key and the latter being a foreign key to ‘parent.id’. How do I indicate to the reader that ‘parent.id’ relates to ‘child.parent_id’. Primary keys are denoted by an ‘*’, optional attributes denoted by an ‘o’ but I can’t find anyway to denote an attribute being part of a relationship.

  20. Alan Lehman Reply

    After starting SQL Developer, I get the message SQL Developer has stopped working and shuts down.
    I have found the following Null Pointer:
    Windows 10 sql dev version 4.15 and 18.x fresh download from today.
    java.lang.NullPointerException
    at org.netbeans.core.netigso.Netigso.findResources(Netigso.java:380)
    at org.netbeans.NetigsoModule.findResources(NetigsoModule.java:177)
    at org.netbeans.core.startup.NbInstaller.loadLayers(NbInstaller.java:630)
    at org.netbeans.core.startup.NbInstaller.loadImpl(NbInstaller.java:356)
    at org.netbeans.core.startup.NbInstaller.access$000(NbInstaller.java:105)
    at org.netbeans.core.startup.NbInstaller$1.run(NbInstaller.java:346)
    at org.openide.filesystems.FileUtil$2.run(FileUtil.java:444)
    at org.openide.filesystems.EventControl.runAtomicAction(EventControl.java:127)
    at org.openide.filesystems.FileSystem.runAtomicAction(FileSystem.java:499)
    at org.openide.filesystems.FileUtil.runAtomicAction(FileUtil.java:428)
    at org.openide.filesystems.FileUtil.runAtomicAction(FileUtil.java:448)
    at org.netbeans.core.startup.NbInstaller.load(NbInstaller.java:343)
    at org.netbeans.ModuleManager.enable(ModuleManager.java:1351)
    at org.netbeans.ModuleManager.enable(ModuleManager.java:1156)
    at org.netbeans.core.startup.ModuleList.installNew(ModuleList.java:340)
    at org.netbeans.core.startup.ModuleList.trigger(ModuleList.java:276)
    at org.netbeans.core.startup.ModuleSystem.restore(ModuleSystem.java:301)
    at org.netbeans.core.startup.Main.getModuleSystem(Main.java:181)
    at org.netbeans.core.startup.Main.getModuleSystem(Main.java:150)
    at org.netbeans.core.startup.Main.start(Main.java:307)
    at org.netbeans.core.startup.TopThreadGroup.run(TopThreadGroup.java:123)
    at java.lang.Thread.run(Thread.java:745)

    During debug command window, also capture the following warning:
    Warning – could not install some modules:
    oracle.javatools_nodeps – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.javatools-nodeps.jar: Not found bundle:oracle.javatools_nodeps
    oracle.javatools_jndi_local – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.javatools-jndi-local.jar: Not found bundle:oracle.javatools_jndi_local
    oracle.jewt_olaf2 – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.jewt-olaf2.jar: Not found bundle:oracle.jewt_olaf2
    oracle.javaxide – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\javax-ide.jar: Not found bundle:oracle.javaxide
    oracle.external.oracle_jrf_adminserver – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.oracle-jrf-adminserver.jar: Not found bundle:oracle.external.oracle_jrf_adminserver
    oracle.external.jxlayer – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.jxlayer.jar: Not found bundle:oracle.external.jxlayer
    org.eclipse.equinox.common – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\equinox\org.eclipse.equinox.common_3.6.0.v20100503.jar: Not found bundle:org.eclipse.equinox.common
    oracle.external.timing – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.timing.jar: Not found bundle:oracle.external.timing
    oracle.ide_print_api – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\ide-print-api.jar: Not found bundle:oracle.ide_print_api
    oracle.ide.library – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\jdev\extensions\oracle.ide.library.jar: Not found bundle:oracle.ide.library
    oracle.ide_osgi – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\oracle.ide.osgi.jar: Not found bundle:oracle.ide_osgi
    oracle.external.jdbc – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.jdbc.jar: Not found bundle:oracle.external.jdbc
    oracle.jewt_core – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.jewt-core.jar: Not found bundle:oracle.jewt_core
    oracle.ide.webbrowser – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.webbrowser.jar: Not found bundle:oracle.ide.webbrowser
    oracle.external.ldap – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.ldap.jar: Not found bundle:oracle.external.ldap
    oracle.external.balishare – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.balishare.jar: Not found bundle:oracle.external.balishare
    oracle.ide.persistence – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.persistence.jar: Not found bundle:oracle.ide.persistence
    oracle.external.xmlparser – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.xmlparser.jar: Not found bundle:oracle.external.xmlparser
    oracle.external.objectweb_asm – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.objectweb-asm.jar: Not found bundle:oracle.external.objectweb_asm
    oracle.javatools_jdk – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\jdev\lib\jdkver.jar: Not found bundle:oracle.javatools_jdk
    oracle.icons – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.icons.jar: Not found bundle:oracle.icons
    oracle.external.odl – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.odl.jar: Not found bundle:oracle.external.odl
    oracle.external.miglayout – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.miglayout.jar: Not found bundle:oracle.external.miglayout
    oracle.javamodel_rt – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.javamodel-rt.jar: Not found bundle:oracle.javamodel_rt
    oracle.external.berkeleydb – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.berkeleydb.jar: Not found bundle:oracle.external.berkeleydb
    oracle.idert – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\idert.jar: Not found bundle:oracle.idert
    oracle.javatools – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\javatools.jar: Not found bundle:oracle.javatools
    oracle.ideimpl.peek – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ideimpl.peek.jar: Not found bundle:oracle.ideimpl.peek
    oracle.ide.macros – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\jdev\extensions\oracle.ide.macros.jar: Not found bundle:oracle.ide.macros
    oracle.java_annotations – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\annotations.jar: Not found bundle:oracle.java_annotations
    oracle.ide.vfs – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.vfs.jar: Not found bundle:oracle.ide.vfs
    oracle.uic – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\uic.jar: Not found bundle:oracle.uic
    oracle.ide_boot – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\ide-boot.jar: Not found bundle:oracle.ide_boot
    oracle.ide.navigator – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.navigator.jar: Not found bundle:oracle.ide.navigator
    oracle.ide – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.jar: Not found bundle:oracle.ide
    oracle.external.oracle_jrf_dms – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.oracle-jrf-dms.jar: Not found bundle:oracle.external.oracle_jrf_dms
    oracle.ide.indexing – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.indexing.jar: Not found bundle:oracle.ide.indexing
    oracle.external.xdb – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.xdb.jar: Not found bundle:oracle.external.xdb
    oracle.external.nlsrtl – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.nlsrtl.jar: Not found bundle:oracle.external.nlsrtl
    oracle.ide.searchbar – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.searchbar.jar: Not found bundle:oracle.ide.searchbar
    oracle.external.xdk – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\external\oracle.external.xdk.jar: Not found bundle:oracle.external.xdk
    oracle.ide.ceditor – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.ceditor.jar: Not found bundle:oracle.ide.ceditor
    oracle.peek – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\lib\peek.jar: Not found bundle:oracle.peek
    oracle.ide.file – org.netbeans.InvalidException: Netigso: C:\sqldeveloper\ide\extensions\oracle.ide.file.jar: Not found bundle:oracle.ide.file

  21. Hi Jeff, please answer what should be a timestamp format used by ORDS POST? as I get it, date field should be like ‘2019-09-11T00:00:00Z’, and what about timestamp? And how to define the mask for to_date and to_timestamp? Is there some tricks?

    • if you query a TIMESTAMP out, you’ll see how we format it – that’s the same way it needs to go back in

    • Let me explain. I got a procedure, which take valid_from varchar2 as input parameter. in the body of my procedure I convert it into timestamp using mask ‘YYYY-MM-DD HH24:MI:SSXFF’, so when I give a string like ‘2014-12-23 00:00:00,098081333’ and run procedure from Oracle it works pretty well.

      The trouble appears when I try to run my procedure through POST method. There are no binds with type, all the conversion are inside the procedure. But wtf?! When I try to call it using CURL, I get ORA-01830! pls, help me understand why does it happen? If I use mask without XFF and valid_from without ‘,nine-digits’ it all works.

      Once more: I send into the procedure only varchar2, all the conversion inside. But from Oracle it works, and from curl – No…

    • You’re asking me to guess – because I can’t see your POST handler code or your cURL command, or the stack trace from ORDS showing the ORA-01830.

  22. Hi Jeff,

    I have a customer facing portal developed with Oracle APEX using custom authentication. I want to create ORDS users for every portal customer I create using PL/SQL. Is this possible? REASON: I have a mobile app recently developed and would like for the app to use the same authentication used by the portal. I can achieve this using OAuth2 by ORDS but I need to create the ORDS user via PL/SQL

    • An ‘ords’ user would be a standalone Jetty user. You can’t create these with PL/SQL.

      Oauth2 says let this other party determine if the user is who they say they are.

      If you go with oauth2, who will you be handing off to?

    • Can I replace the authentication URL for “authorization_code” implementation of OAuth 2 to say an Oracle APEX login page. What I hope to achieve is to very similar to what google provides for OAuth2 authentication in Oracle APEX. Just that in this case I would like the mobile app to use “my Oracle APEX” login page then proceed to access APIs hanldles

    • I do have a table of users and their hashed passwords. How do I use this instead of the ords (Jetty) users

  23. Extеnso will completely ѕtгaighten thе hаir, it relaxes the curl and makes it easier to flat iron or blow out.
    Detoxifying yoᥙr body is the solіtаry way of cleansing your body of these toxins.
    You can do cardio, dancе, step and қіckboxing in this game.

  24. Mike Perkins Reply

    Hi Jeff,
    In the Connections Pane I want to be able to connect as one user but display the object tree for another user that I have access to. Currently I have to navigate to the “Other Users” node and then apply a filter to isolate the user I want to traverse. This leaves the tree of the connected user visible above the “Other” User. Can I hide the entire “Connected” user tree and just display the “Other” User tree?

  25. Harry Boswell Reply

    I’ve imported a SQL Server database, and I’ve discovered that there are a fair number of inactive foreign keys. Is there a way to tell Data Modeler to delete those from the model?

    • Hmmm…I like a challenge, let me play with this tomorrow

      But

      FKs are important – if only to tell a story in your model. Are you sure you don’t need them?

    • This is an old, not-well-designed application developed by an ever-changing project team. It’s still sitting on SQL 2000. An example – for some reason, on one table, there is one active foreign key – and four that have the exact same constraint, but they’re inactive. There are about 34 FKs inactive out of about 200, and most are like this.

    • I think you’d have to write a transformation script to find those and auto-delete them.

      I can show you how to find them with the search pretty quickly, or I can try to write the script for you.

    • I’d prefer to know how to do it – I think this redesign may be an iterative process.

      Thanks!
      Hary

Reply To Daníel Cancel Reply