Questions

Ask Tom:I would like to migrate a PL/SQL Web Toolkit application from an on-prem database instance to the Oracle Autonomous Database. I see references to the PL/SQL Gateway via ORDS (I think) in documentation and administration screens but I'm struggling to co...

Hi everyone,We’re developing an APEX app that handles Excel files, and we’ve run into a problem when trying to export the app from one Workspace and import it into another.<b>The main issue:When we export the app and attempt to import it into a different Works...

Hi there,I am facing an issue wherein i need to have more than 1000 values in IN Operator of query.Please suggest some way around for the same .here is the code snippet for you.Note: RMID IN can have 1000+values .Also had tried using OR RMID IN ()-for values g...

I thought I could take what Chris showed me in my original question (https://asktom.oracle.com/ords/asktom.search?tag=looking-for-help-with-json-object).However, after 2 days, I have not made any progress.The JSON data - { "recall_control":[ { "it...

Hello,I am executing a package on multiple threads. Our package is for deleting data in bulk.Whenever I am running the package on multiple threads I am getting a deadlock.On checking the trace file I found the delete statement which is causing deadlock. But th...

Hello,We have migration project form Oracle database 11g in Exadata server, to 19c in ODA server, when we tested the query in the new server with client tool such as Sql developper, Sqlplus and Sqlcl, the connection was lost after 1 hour of inactivity, the onl...

Tom,How can we display PDF files stored in the database,using htp.p (OAS PL/SQL cartridge )calls and dbms_lob ?We are developing a document archival and display app.Using ctxload, I can upload the files. Now, I would liketo display the file in its native forma...

Hello,I wanted to ask about new 23C feature - Schema-level Privileges: is it possible to combine it with "WITH GRANT OPTION"?According to documentation https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/configuring-privilege-and-role-authoriza...

<code>SQL> alter session set standby_max_data_delay=1;Session altered.SQL> show parameter standby_max_data_delaySQL> select * from v$parameter where name='standby_max_data_delay';no rows selectedSQL></code>Where can I see my current setting of standby_max_data...

I am using the following IIS Server for App server.ODP.NetOracle 10.2.0After 30 minutes of idle time i get the error ORA-03135: connection lost contact.The Error is same even if I use Sql*plus.I asked the network group to increase firewall to 4 hours which the...

I am trying to integrate Microsoft Office365 Outlook's SMTP with Oracle Apex 22.1(Running on Amazon RDS for Oracle 19c). I have used the following configuration on Apex:SMTP server name: smtp.office365.comSMTP port: 587Username: <my-email-id@outlook.com>Passwo...

Hi,Being a DBA, how can we verify if private database link created in application schema is working fine? If application schema's password is not known to DBA.We can verify public database link using select * from dual@public_db_link; How private db links can ...

Hello, I am just lost here. I have a very simple requirement using sql developer.I need to extract user creation script for a list of users.How on earth do I do this please help .Why have they made so simple things so difficult to do or even find.I click ...

Dear Tom,I have a question related to Oracle EBR.We are using Oracle 19C (Enterprise Edition) & now moving to be EBR compliant.Currently we do have DML triggers defined on tables.These table have foreign key constraints defined with cascade on delete option.Fo...

We use OCI GoldenGate Microservice to replicate tables from Oracle Database to BigData.I was tasked to create a process to replicate any "ALTER TABLE ADD COLUMN" statements to let bigdata team modify schema safely.Tested solution using database trigger in dedi...

Hi,Had problems with SQLLive, (500 response), therefore the examples are her.I have a strange behaviour with execute immediate, where it behaves differently from within a PL/SQL procedure than it does when running it standalone.Here is the example:I create a s...

Attempting to learn and make use of JSON data within a table. Stuck on the following and would really appreciate some help...Looking for help to create a list of ITEM_IDs where a match is found in the JSON object. Sample column data - (column: recall_control_j...

I"m looking for guidelines on how to architect a new APEX solution for migrating legacyOracle reports to APEX.We have 67 seperate municipal government entitiesin 67 seperate Oracle instances. Some are 12c someare 19c. They are spread across 4 servers.Table str...

Hello,In this query : <code>select id, to_char(txn_date, 'yyyymmdd'), count(*) from table1 where to_char(txn_date, 'yyyymmdd') > '20250101' group by id, to_char(txn_date, 'yyyymmdd') order by to_char(txn_date, 'yyyymmdd');</code>Will t...

from the oracle10g concepts guide"Oracle recommends that unique indexes be created explicitly, and not throughenabling a unique constraint on a table.Alternatively, you can define UNIQUE integrity constraints on the desired columns.Oracle enforces UNIQUE integ...