Ask A Question

5,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!

6,772 Comments

  1. Avatar

    Hi, is there a way to get a fresh timestamp in the prompt each time you hit enter in SqlCl? In SQLPlus I was able to use this as my prompt:

    SET SQLPROMPT “_USER’@’_CONNECT_IDENTIFIER _PRIVILEGE _DATE> ”

    but in SqlCl, it seems like the timestamp is set once when you connect, but doesn’t change after that.

  2. Avatar

    Hello Jeff,
    how to permamently disable (to not show this box) Save dialog for Worksheet when i close worksheet or close application?
    “… has been modified. Save changes?”

  3. Avatar

    Using SQLDeveloper, is there a way to write a hierarchical report that can expand and collapse nodes in a tree structure in a similar manner as the connections expands to shemas and its objects.
    If not directly in SQLDeveloper, any suggestions on the minimalistic approach could be.

  4. Avatar

    Hi Jeff,

    I am starting to use ORDS to REST enable my PL/SQL APIs, but I have a couple of questions.

    1) Eventually, I will need to enable authentication in order for my users to use the web services. What would be the best OAUTH method to implement authentication for internal users?

    2) Is there any way that the database can automatically “know” who the user is using the rest service when using OAUTH? This information would be very valuable for database auditing etc. along with any additional home-grown application security that may be used during the rest call. I know the owning schema and proxy user information is available, but this is still generic.

    Many thanks in advance,
    Mark.

    • Avatar

      Hi Jeff,

      Sorry to nudge, but did you get chance to look at this question?

      Many thanks,
      Mark.

    • thatjeffsmith

      I looked at it, and I thought about it.

      Here’s what I would do.

      Build a REST API to return a nice little JSON doc. Then use that with a REACT/Python/Whatever app you like to build your report.

    • Avatar

      Hi Jeff,

      Thanks so much taking the time out of your day to reply!

      Unfortunately I am not after a report in this case and I apologise if my question wasn’t clear.
      My question was more about what ORDS does automatically after successful OAUTH authentication with respect to setting any database environment variables (e.g. SYS_CONTEXT) in the connection from the pool before executing the REST call. Using standard Oracle database auditing, I would like to see the user/client who initiated the REST API through ORDS.

      Many thanks in advance,
      Mark.

    • thatjeffsmith

      Sorry, you had asked multiple questions, my answer was for your other question on hierarchical…

    • thatjeffsmith

      I think you want to look at the pre-hook feature. It allows you to implement finer-detailed authentication, and lots of customers use this for example to enable things like Virtual Private Databases (VPD) – where a user only gets access to certain rows in a table. Here’s a great external write-up on that.

      The authenticated user for an oauth2 client is the CLIENT ID associated with that client, so whoever you gave that client to…unless you could pull additional info off the request header.

    • Avatar

      Hi Jeff,

      Just what I was looking/hoping for!!

      Thanks

  5. Avatar

    Please can you tell me how to preserve blank lines in 20.4 as this used to be possible but I’ve looked and used the search feature but it seems to have been dropped?

  6. Avatar

    A Data Modeler question – when importing a model from an Oracle db data dictionary, is it possible to filter on a list of tables from a text file? There are several thousands of tables in a schema and I want to only import few hundred based on a list I have in Excel.

    Thank you advance for any help!

  7. Avatar

    Total newbie question here, I’m afraid. Apologies for that. I’m a sysadmin, not a DBA, and my DBA asked me to install ORDS (22.1) against an Oracle 19c DB (or at least she did the configuration once I’d installed it). The install went fine, and I even got it running in Tomcat without any issues, but every time we try going to http://:8080/ords/ all we get back is

    404 Not Found
    2022-06-24T10:54:13.286453205Z | 9oJxaAU6iB0lWtiUOCPb5A | ORDS-22001

    The procedure named apex could not be accessed, it may not be declared, or the user executing this request may not have been granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access. Check the spelling of the procedure, check that the execute privilege has been granted to the caller and check the configured security.requestValidationFunction function.

    Now, we don’t have APEX installed in this DB at all, and the docs say it doesn’t need to be. So what might I/we be missing, please? We’ve tried a simple DB connection with the ORDS_PUBLIC_USER and the password extracted from

    ords –config /etc/ords/config config get –secret db.password

    and it worked, so it’s not a password thing. Any thoughts, please?

    With thanks,

    Ben

    • thatjeffsmith

      Welcome newbie! Don’t apologize or feel bad.

      /ords is the base URI for Tomcat to know you’re talking to the ORDS web app.

      Now, if you’re not using APEX, there’s nothing for ORDS to serve at that URI.

      Once you have a schema REST enabled, you can use that account to login to SQL Developer Web if you enabled that on the install.

      Go to localhost:8080/ords/sql-developer

      Then supply the schema name, and then again with the password.

      Then go to the REST panel. from there you can enable a table or hand-code a REST API.

      Before you can use ORDS for anything, you’ll need to enable a schema and publish a REST API on that database. Then you can call that.

  8. Avatar

    How can I get SQLDeveloper to set roles after login so the connection and schema browser show the objects accessible via those roles? I.e., apply the role to EACH session that SQLDeveloper establishes with the database?

    I’ve looked and cannot find where I can tell SQLDeveloper which roles to apply upon login. The user id does NOT have the roles default in the database; they have to be turned enabled after login to the database (by database manager policy because we don’t want every session to have the roles; only enable when needed and intentionally turned on).

    Or is that the requirement… that the roles are default so the database enables them.

Write A Comment

RSS
Follow by Email
LinkedIn
Share