APEX
Discussion List
-
How we can convert big data file into single vector chunkIs there any way to convert complete CLOB data into single vector chunk. if yes which function we can use to convert. Currently i am using TO_VECTOR(VECTOR_EMBEDDING(doc… -
Is the OCI in Johannesburg down? I get this Apex errorSummary: I have a issue that all my Apex apps dont work on the Johannesburg South Africa cluster If you click on this link you will see that Apex has an issue. Oracle AP…
-
APEX_MAILSummary: Hi, Trying to use apex_mail from Apex running on ATP in the Free tier of the Oracle Cloud and I think I got all the setup done correctly : Note: There was the n…
-
How can I apply dynamic filters based on user roles and departments in Select AI?How can I apply dynamic filters based on user roles and departments in Select AI? When we create profile on the data (like Sales Data) so it contain all data from differ…
-
403 Error when Uploading ZIP Files in Oracle APEX on OCI Integrated with Oracle ERPI'm experiencing an issue with my Oracle APEX application, which is integrated with Oracle ERP and deployed on OCI (Oracle Cloud Infrastructure). It’s important to note …Pony Salvaje 16 views 2 comments 0 points Most recent by Avishek Mazumdar-Oracle Autonomous Database -
Apex not working after update, invalid packagesSummary: Apex is not working after its update . I cant even see Apex instance, i can use database. I see 2 invalid packages bodies APEX_240100.WWV_FLOW_CGI APEX_240100.W…
-
Uncommited Multipart Uploads - Storage BucketHi Team, We have uploaded files from onpremise linux server to OCI object storage bucket using below commands. sample :. oci os object bulk-upload --namespace-name axqui…
-
Why are my newly created 23ai databases going straight from "Provisioning" to "Unavailable" ?Summary: I can't migrate my 21c DB to 23ai simply because I can't create and start a 23ai DB. Content (please ensure you mask any confidential information): I'm trying t…
-
It is possible recover / restore from last backup AlwaysFree 21c databaseSummary: Hello everyone, I know, OCI has informed that the AlwaysFree 21c databases will be removed. But TBH, I have found in my mailbox just one e-mail about it. But ok…
-
Inporting application from an Autonmous database to another on OCIHi, I am on alway free database unsing APEX database. I wouldlike to import application from one database to another. What are the steps involved ? Best regards. -
The Autonomous Database operation failed due to an unknown error.Summary: Good morning, My OCI Autonomous Database is currently in a STOPPED state and will now not restart. When trying to restart, it takes around 20 minutes and then g…
-
Issues running Oracle Apex on ATPSummary Apex shows blank page when trying to access via tools menuContent Hi,I have an Autonomous Transaction Processing Database instance set up on the Oracle cloud. Th…
-
How to replace new line character in one of the value in CSV during DBMS_CLOUD.COPY_DATA call?Summary: This DBMS_CLOUD.COPY_DATA API is failing during importing data from Object storage to ATP that is having a new line characters in one if its value. We are tryin…
-
ATP in Private subnet, how to access database action (sql developer web) and Apex over internetSummary: Hi Team, We have an ATP provisioned in private subnet, how can we access the APEX and Database Action over internet, any pointer to that would be helpful? Thank…
-
IP address of public ADWSummary: Hi, We wish to connect to a compute instance (ODI MP) from ADW via Apex. For this ADW, network type is set to 'Allow secure access from anywhere', so there's no…Debadrita Ghosh-Oracle 24 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
How to Migrate Autonomous Database with Workload type: APEXSummary: I am following This does not work for Autonomous Database with Workload type: APEX As Oracle Doesn't allow external connection Content (please ensure you mask a…
-
AI Assistant button not visibleHi, I have upgraded to APEX 24.1 on OCI. I cannot see the button AI Assistant in the SQL code editor. The bottom page of APEX shows relase 24.1 is installed :
-
invalid credentials.I am using Always Free AD on the free OCI. I have installed Oracle. But when I try to connect to APEX on the cloud, I get an error message "invalid credentials." How to …Christian Pitet 2 13 views 13 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
English language on Interactive reports options instead of frenchHi, I am using APEX 24.1 on OCI. The interactive Report button is "Actions" and the Actions are in english. And the systems messages "Row updated" for example, are in En…Christian Pitet 2 21 views 12 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
ORA-12530, TNS:listener: rate limit reachedSummary: How do I trouble shoot this error ? Content (please ensure you mask any confidential information): I observe this error in following configuration Automomous da… -
Getting ORA-43912 whilst trying to create a page as a copy on Apex using 23aiSummary: I've created a new 23ai Apex instance and imported three applications from an Apex instance running on 21c. When trying to copy a page between two of these appl…Martin Bocutt-Oracle 55 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
APEX REST BASED LOV Don't show all valuesSummary: APEX REST BASED LOV Don't show all values Content (please ensure you mask any confidential information): Hi, I have created a Rest Data Source Based LOV and it …
-
Advantage of ORDS service call in vbcs and cons of OIC call in vbcsHi experts advantage of ORDS api over OIC calls in vbcs . suppose ORDS being called in OIC for VBCS services what is the disadvantage its better approach or not? what is… -
ORA-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !Hi, The current situation on my Always Free tenant/Autonomous Transaction Processing DB: jofodb/jofodb1: SQL> select round(sum(bytes/1024/1024/1024),2) Size_gb from dba_… -
APEX Report with SQL using WITH clause function gives error.Summary: Below query works fine in APEX SQL Workshop, but gives error (ORA-32034: unsupported use of WITH clause) when creating an APEX Interactive report. with FUNCTION…
-
I keep getting an error to upgrade. Is there a fix for itSummary: I was on a free trial period, and I want to upgrade, but when attempting to upgrade it tells me that it fails due to the below: I have checked the address of my…
-
Using Apex with ATP for Building Web AppHi Team, We are assessing Oracle Apex(comes with ATP DB) as a platform to build Web App/extension to Oracle Cloud ERP. There would be around 10 extensions to be built an…
-
Oracle APEX 503 service unavailableSummary: Service Unavailable HTTP Status Code: 503 Request ID: 0ee5370a491db4c7f7674c355fbd8502 Request Timestamp: 2024-01-12T13:59:18.785698Z The connection pool named:…
-
Unable to import APEX Application including backup filesSummary: I have a newly created OCI account for our school and I cannot import an APEX application from a different workspace. Content (please ensure you mask any confid…
-
Connect MYSQL Database in APEXSummary: I have a requirement to connect with external MYSQL database and bring the data to Oracle Database Cloud. Content (please ensure you mask any confidential infor…