21 responses

  1. tmbs
    May 7, 2014

    Are there any plans to fix the “Go to Declaration”?

    • thatjeffsmith
      thatjeffsmith
      May 7, 2014

      How do you mean, what’s broken?

      This works for me.

      [sql]
      declare
      NAMES varchar2(100);
      begin
      select GET_EMP_NAME(30) into NAMES;
      DBMS_OUTPUT.PUT_LINE(NAMES);
      end;
      /
      [/sql]

      Put cursor on function call, right click, open declaration, opens GET_EMP_NAME(). What are you seeing?

      • tmbs
        May 8, 2014

        With tiny code fragments as in Your example it works fine, however when I try to repeat that in a package body of e.g. 4000 lines by Ctrl+right clicking on a procedure or function from another package (e.g. 2000 lines) nothing happens at all.

        Current machine is running Win 8.1 x64, JDK7u55 x64, SQL Developer 4.0.2 but that didn’t work on anything I’ve tried (Win7, Ubuntu, etc) with earlier SQL Developer versions too.

  2. Allan Lewis
    May 7, 2014

    According to the list of “bugs fixed”, one is “RUN PACKAGE DIALOG RANDOM MEMBER ORDER”. However, this doesn’t seem to be the case. I just ran 4.0.2 and opened the “run” dialog for a package with about 50 procedures in it, and they are still not in alphabetical order. (Or in any other sensible order.)

    http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-bugsfixed-v402-2197030.html

    • Allan Lewis
      May 13, 2014

      Can anyone else confirm what I’m seeing here?

    • thatjeffsmith
      thatjeffsmith
      May 13, 2014

      Hey Allan, sorry for taking so long.

      What I THOUGHT had been fixed for 4.0.2 did NOT get checked in for the final patch release. If we have another patch for v4, it will be in there.

      • Allan Lewis
        May 13, 2014

        Thanks Jeff – I look forward to v4.0.3…

  3. Kartik
    May 13, 2014

    I am trying to Connect the InterSystem Cache database to SQL developer. Can you help me?

    • thatjeffsmith
      thatjeffsmith
      May 13, 2014

      Are we talking the Modeler or SQL Dev proper? If SQL Developer – then ‘no.’ If the modeler, you can try a generic JDBC connection. It will work as well as the driver implements the JDBC ‘database’ standard.

  4. tomasz lesinski
    May 13, 2014

    Hi Jeff

    Question

    Is there possiblity in new sqldeveloper to write/delete/shift in many lines in the same time. It’s very usefull functionality. It’s option ALT+mouse in notepadd++.

    Regards
    Tomasz

    • thatjeffsmith
      thatjeffsmith
      May 13, 2014

      Not today, and maybe not ever. We’re never going to be the slick editor that Notepad++, Ultraedit, fill_in_the_blank editors are. However, you can setup an external editor and launch it from the worksheet to do your ‘fancy’ stuff. Have you seen this?

  5. Matteo S.
    June 10, 2014

    Hi, i’m unable to run sqldeveloprt 4.0.2 on ubuntu.
    i always get a core dump error:

    Oracle SQL Developer
    Copyright (c) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

    LOAD TIME : 3259#
    # A fatal error has been detected by the Java Runtime Environment:
    #
    # SIGSEGV (0xb) at pc=0x00007f0f6f46cbe0, pid=20986, tid=139705338750720
    #
    # JRE version: Java(TM) SE Runtime Environment (7.0_60-b19) (build 1.7.0_60-b19)
    # Java VM: Java HotSpot(TM) 64-Bit Server VM (24.60-b09 mixed mode linux-amd64 compressed oops)
    # Problematic frame:
    # C 0x00007f0f6f46cbe0
    #
    # Core dump written. Default location: /home/matteo/sqldeveloper/sqldeveloper/bin/core or core.20986
    #
    # An error report file with more information is saved as:
    # /home/matteo/sqldeveloper/sqldeveloper/bin/hs_err_pid20986.log
    #
    # If you would like to submit a bug report, please visit:
    # http://bugreport.sun.com/bugreport/crash.jsp
    #
    /home/matteo/sqldeveloper/sqldeveloper/bin/../../ide/bin/launcher.sh: riga 1193: 20986 Annullato (core dump creato) ${JAVA} “${APP_VM_OPTS[@]}” ${APP_ENV_VARS} -classpath ${APP_CLASSPATH} ${APP_MAIN_CLASS} “${APP_APP_OPTS[@]}”

    • thatjeffsmith
      thatjeffsmith
      June 10, 2014

      Your solution is in this OTN thread

  6. Aljaz
    June 19, 2014

    If I try CTRL+Right Click on a table, it doesn’t open it.

    I was using a SQL Dev 3.x.x version and it worked like that in it (I am using the software for about two months now).

    Not working?
    Is there an alternative? Go To declaration in drop-down menu also doesn’t open it.

    Thanks

    • Aljaz
      June 19, 2014

      Sorry, i meant CTRL+ (LEFT) Click.

    • thatjeffsmith
      thatjeffsmith
      June 20, 2014

      Does it hyperlink, and then not open? Or does it not hyperlink first?

  7. Aljaz
    June 23, 2014

    Hi, i’ve tried again. It does not hyperlink at all. When i press CTRL it shows “Click on an indentifier with Control key down to perform “Go to declaration””, but nothing happens.

    – Maybe it can’t link it to the database properly, but it’s funny beacuse in 3.0.0.4 it works out of a box.
    – Maybe it’s got something with the import, everything was just auto-imported from this version, where in 3.0.0.4 the database was imported manually. The connection works and shows tables and result queries OK.

    • thatjeffsmith
      thatjeffsmith
      June 23, 2014

      What does your code snippet look like?

      With an empty worksheet, type

      select * from hr.employees;

      Does the ctrl-hover-click work on hr.employees?

      • Aljaz
        June 26, 2014

        A simple example like yours works.
        I’ve then tried to copy the code in a new file, changed some lines and it worked. Will see how it goes in the future.

        But new thing has come up , for every click on table it shows a information popup: “Too many objects; Only 2 records will be displayed. Please refine your search criteria.”

        This has already been discussed in a very fresh thread (). I have two DB’s imported, they are almost the same (like test&production). Allthough I had explicitly selected to use the test database via “SQL Worksheet” icon, where I selected the test database (it’s name is also present in current worksheet tab).

      • Aljaz
        June 26, 2014

        The link to the thread is –> Oracle Community Thread

  8. Ursula
    September 3, 2014

    Hi Jeff,
    We need to create partitions for each day of a year for a number of databases and we’re wondering if there is API we could use while working in SQL Developer Data Modeler to generate these partitions rather than manually creating and maintaining them through the GUI.
    Thanks!

Leave a Reply

 

 

 

Back to top
mobile desktop