oracle-12c | Docker image with Oracle database server | Database library

I have my Oracle 12C installed in docker and it run in port 1521. This is the command i used to run my oracle image

Athena (Trino SQL) parsing JSON document (table column called document 1 in Athena) using fields (dot notation)

If the underlying json (table column called document 1 in Athena) is in the form of {a={b ... I can parse it in Athena (Trino SQL) using

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

I'm getting the above message when trying to create a package. I can simulate with a very simple procedure and select statement. My understanding is that have SQL select access for a user does not translate to PL/SQL (package) access for the same user, and that an option is to use roles. This has not worked for me.

This is all done with the same user (not apex_180100).

Showing the issue:

This SQL works. It doesn't make sense, but proves that I can select from the tables.

So I recently had an error with the default oracle db.backend of django. I performed a raw query directly on my db and it throw me an "django.db.utils.DatabaseError: ORA-24450: Cannot pre-process OCI statement". I knew the query itself was valid, because it ran in the old flask application as well as in table plus.

I googled and did not really find anything useful on that topic, other than the generic error description.

I will put the answer for future readers here. Hopefully it is helpful.

I have a problem with oracle 12c when trying to create an functional based index. So I have a table like this:

I granted the user SYSBACKUP privileges and followed the steps in this link: https://blog.toadworld.com/2017/05/29/sysbackup-and-sysdg-permissions-in-oracle-12c

However, after further analysis, it is clear that he makes a user, grants him SYSBACKUP privileges, and then restarts the database.

After further research, I have found out that I need to use something called 'Rman' but

I cannot connect to rman from my SQL plus :

I'm trying to install a fresh new downloaded Oracle Database 19c on my Windows 10 Home and I receive the error: Failed to set ACL's for specified User.

In the logs details I see mentioned updating registry key HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraDB19Home1 I don't see nothing unusual there.

I followed this guide and I:

• run net share
• run net use \\localhost\c$
• I Stop and Disabled and the service OracleRemExecServiceV2
• I also run with PowerShell as Administrator the command setup.exe -ignorePrereq -J"-Doracle.install.db.validate.supportedOSCheck=false"
• Of course I have also created a brand new user for Oracle with a brand new password. And I also tried the Windows user within the Administrator group
• I went to regedit and on HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System I created a new DWORD value LocalAccountTokenFilterPolicy set to 1
• I disabled Windows Defender and the whole Firewall
• Then I tried the Debug mode so run from an elevated prompt I run setup.exe -debug -ignorePrereq -J"-Doracle.install.db.validate.supportedOSCheck=false" and as result I got:

I have a homepage with tags to views. It is a simple master/detail relationship where the Homepage is a catalogue of products and the Product detail page/view shows information on each item.

When I first launch the website and click on an item on the Homepage view (e.g. URL: http://localhost:8080/100-sql-server-2019-licence), the Product view gets loaded and the product detail loads fine.

If I then press the back button in the browser to return to the Homepage and then click on a different Product (e.g. URL: http://localhost:8080/101-oracle-12c-licence), the URL in the browser address bar changes but I get the previous product's information. Its lightning quick and no new network calls are done which means its just showing a cached page of the previous product. If I then hit the refresh button while on that page, the network call is made and the correct product information is displayed.

I did a search online but couldn't find this problem described on the search results. Could anyone point me in the right direction of how to cause a refresh/re-render of a route when the route changes?