My instant thought is that ORDS is not installed properly. What I would do. 1) Check the output from the installation. Is there anything there that would suggest the installation failed? 2) Search for the ORDS package in DBA_OBJECTS. Is it there? 3) Grant execute permission on the ORDS package to your user. This should not be necessary, so I would question the validity of the installation if this is needed.

@@TheTimHall i found it, tim.. my ORDS was installed at pluggable database.. while my database on CBD.. i reinstalled my oracle but uncheck create as pluggable database and it solved.. Thanks alot for your hint..

Any existing plans that use literals will still be used. Cursor sharing only affects newly parsed SQL. You can flush your shared pool to remove the SQL using literals, and they shouldn't come back. Just remember doing the flush will mean your shared pool has to warm up again, so there will be a lot of hard parsing until it is warmed up. :)

No idea. This is a vagrant build on Virtual box, not Azure.

@@TheTimHall thank you very much. I installed virtualbox and vagrant on Azurre VM. Btw just read is recommend using Oracle RAC on Docker on KVM or virtual box on-prem or in Oracle Cloud. So it's not supported on Azure. It must be a network issue

@@andreacortemiglia3182 I'm not sure what I would expect from this. Installing VMs inside VMs seems rather like a recipe for disaster.

There are lots of interfaces. - SQL*Plus - Which comes with the product. - SQLcl - A lightweight Java utility, that is similar to SQL*Plus. - SQL Developer - A Java IDE for Oracle. - SQL Developer extension for VS Code - As the name suggests, an extension for VS Code that gives you some of the functionality of SQL Developer.

Sorry. I've never used that.

In General term I am trying to integrate ORDS with an external identity provider for OAuth-based authorization. Use Case: I am getting a token from an external identity provider (RHSSO), passing it as a Bearer token to ORDS, and ORDS authenticate the token with the external provider (RHSSO). Thank you!

@@hargunsuri Sorry. I've never done that. It might be worth raising it in the Oracle community forums to see if someone there knows the answer.

Thank you Tim Yes I have done that.

You can't. Once they are in, that's it. This is not a password manager. You should use a password manager to keep all passwords. I use KeePass, but there are several.

".xslx" files work the same as all the other file types.

I don't believe so. The checksum itself is written into the file, so I'm not sure you could test it externally to the import, since by writing the checksum to the file, you've actually altered the checksum. :)

You can't. See restriction in docs. docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/PIPELINED-clause.html

You create a service with the correct instance association, then create a job assigned to that service.

ORDS is a PL/SQL gateway. In order to use ORDS you have to install it. You can run it in standalone mode, or under a Java container such as Tomcat. This is how you get access to port 8080, or any other port you define. ORDS then connects to the database, which is where the data and the ORDS package are. Whenever you read anything about ORDS, it assumes you are running ORDS with a connection to an Oracle database. oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat-22-onward

@@oracle-base Thank you

@@oracle-base So if you have Oracle Apex already installed then you are sorted on the ORDS issue, you should already have the ORDS Gateway right?

@@togaramutasa9669 APEX and ORDS are two separate products. You can install APEX without using ORDS and vice versa. ORDS is the preferred gateway for APEX, so if you are using APEX it is probably you also have ORDS installed, but it's not guaranteed. You need to speak to whoever set up APEX in your company.

How do you protect any password? Only tell the people who need to know it. If you think it is compromised, change it.

​@@TheTimHall Sorry, I meant that I do not want to expose it in my mobile app code. Trying to find a way of protecting the client secret and not need to hard code it in the app.

@@MrZtapp One again, the same as you would for any other protected resource in your application.

@@TheTimHall Well this is a game (Unity3d) and the only resource I really need to protect is the access to the JSON database where I have all game and player data. As of now I have the client secret hard coded in the code and is currently researching and key management system I can use. However, I know very little about this topic.

@@MrZtapp I know nothing about Unity (apart from they have an atrocious pricing model that has lots of bad press). I suggest you ask on a Unity development forum, as this is not an ORDS issue. It's a programming issue.

You can turn on SQL trace for the user and check that. I'm not exactly sure why you would care about execution plans for DDL and procedure creations though.

@@oracle-base thanks for your reply. Thought that could be rather interesting to enhance a log such as "<script_name> ran successfully in 100ms" by adding "Table created" so that the implementer has clear picture of what has ran.

I'm not sure what you mean. Implicit statement results are an option to interact with the ref cursor contents, but it is an alternative to the traditional approach.

As you've discovered, it doesn't. Oracle deprecated LONG columns a very, very long time ago. As a result, most features added since that deprecation do not support LONG columns. You should migrate from LONG to LOB (CLOB or BLOB).

Read this. oracle-base.com/articles/misc/append-hint

Just drop the column.

They will be similar. Effectively a hot clone takes a backup and transports it. I typically do this using a PDB clone, as it is logically simipler.

Yes. You pass in a directory name and file. The example does this, so not sure why you would need a separate example. As explained, it need you to have APEX 19.1 or newer installed in the database.

It's MobaXterm. The font is the default font in that terminal.