Application Development
Discussion List
-
Can we build the APEX application on AWS RedShiftCan we build the APEX application on AWS RedShift or Microsoft SQL Server Developer (64-bit) database? -
How to insert comma delimited values in one column using DBMS_CLOUD?Summary: Hi Team, We are trying to insert the bulk data using DBMS_CLOUD_COPY_DATA/DBMS_CLOUD.CREATE_EXTERNAL_TABLE. In source file, We have few columns like tags/additi…
-
DPY-6000: Listener refused connectionSummary: Unable to connect to ATP DB via Python code DPY-6005: cannot connect to database (CONNECTION_ID=""). DPY-6000: Listener refused connection. (Similar to ORA-1250…Monish Munot-Oracle 50 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
Ajax call returned server error ORA-01840: input value not long enough for date formatSummary: today i am getting the following error when passing a page item value (date picker) from one page to another page. It has never happened before. It is a strange…
-
cant start a stopped autonomous db, when I want to see the details I got an errori cant start a stopped autonomous db, when i want to see the details i click its name and i got an error: "An unexpected error has occurred: Authorization failed or requ…
-
When is APEX 24.2 getting released for Oracle Cloud ATB Database.24.2 has the Bug Patch for 37117164 Can anyone say when it's getting released
-
DPY-6005: cannot connect to database (CONNECTION_ID=qkBuaD1Uq1JopfePKo/5rA==) pythonanywhere.com ATPPython connectivity with ATP DB is working fine on local machine using the below code import oracledb Define connection detailsconnection = oracledb.connect( user="admin…
-
how to do loadjava in ATP- Java stored procedure in ADB ?-Summary: Hi Could someone please guide how to use the loadjava tool as per the documentation to create the java files as stored procedure into ADB. I have the java sourc…
-
dbms_cloud.copy_data Issue : ORA-20000: ORA-29283: invalid file operation: nonexistent file or pathWe are calling the dbms_cloud.copy_data procedure to download the file data in ATP db. It was working fine until couple of days back.Suddenly it has started throwing bel…
-
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…
-
Authentication of Accessing ATP DB objects in OIC without storing creds in OIC ConnectionWe have an ask from one of our client's IT security team that we do not store the ATP wallet and credential details within the OIC connection. Instead, is there a way to…
-
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…
-
how to create ords api to send file as a multipart attachment in requestSummary: Hi Experts How to create a ORDS REST API to send a file as a multi part form data and insert into a table column of blob type. Please help me. I do not want to …
-
A quick and easy way to migrate your Always Free 21c instances to 23aiSummary: With the introduction and availability of Oracle’s latest database version, Oracle Database 23ai, in our Always Free tier, you can now migrate your Always Free …Keith Laker-Oracle 133 views 22 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database -
[URGENT] Please move all Always Free 21c instances to 23ai as soon as possible!With the introduction and availability of Oracle’s latest database version, Oracle Database 23ai, in our Always Free tier, you can now migrate your Always Free 21c datab…Keith Laker-Oracle 242 views 18 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
A quick recap of ADB announcements at CloudWorld Las VegasA quick recap of ADB+GenAI announcements from CloudWorld Las VegasA couple of weeks ago we held our annual customer conference in Las Vegas. During the event, there were…
-
The extended JSON data type REGULAR_EXPRESSION is not supportedSummary: I have an application that uses the MongoDB API for Autonomous JSON Database. I was attempting to do a case-insensitive find query on a collection using regex b… -
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…
-
Your Free Guide to Everything Autonomous at Cloudworld 2024To get you ready for CloudWorld 2024 in Las Vegas, I have put together a quick must-see guide covering all the important sessions, workshops, and tutorials by the Autono…
-
Autonomous Database on OCI and Oracle EBS version 12.2.10Summary: Is the current version of the Autonomous Database on OCI offering compatible with Oracle EBS version 12.2.10, which operates on Oracle 19C? Content (please ensu…
-
How to rollback a tableHi, I am on always free offer on OCI. I have made a big mistake I have deleted records from a table. is it possible to rollback the table 24 hours ago ? Best regards. Ch…Christian Pitet 2 33 views 11 comments 0 points Most recent by Christian Pitet 2 Autonomous Database -
Update for Autonomous Database Severless for July, 2024We are continually adding new features and enhancements to Autonomous Database, and here are the latest updates along with information about the most recent sales wins: …
-
My application login attempt return 503 error - Service UnavailableSummary: Unable to login into application, error 503 service unavailable Content (please ensure you mask any confidential information): When I look in dashboard, db is n…
-
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 …
-
Insert / Update records in ATP database from CSV File with 1-2 million recordsSummary: Content (please ensure you mask any confidential information): We have scenario as per below : 1) Customer will provide the datafile by using upload button in U…
-
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…
-
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: Hi to all, we are not able to create an Autonomous Database even though we have only 1 ADW. The error we get is: "Account has reached maximum limit for Always F…
-
ANNOUNCEMENT - FREE 1-DAY AI WORKSHOP FOR ARCHITECTS AND PRACTITIONERSSign up for our free 1-day workshop to learn more about Oracle's self-service modern data platform architecture. The Oracle Autonomous Database Product Management team i…
-
SQL developer web with Multiple TabsSummary: When using SQL developer WEB upon a ADB, only one tab of SQL code is allowed; my organization needs possibility to have multiple tabs to launch queries in paral… -
retrieving old version of code ( database package)Summary: how can I retrieve the old version of the code ( database package)? Content (required): I have compiled the wrong version of a database package and lost the rig…