I recently began learning Oracle Apex; any advice, suggestions, or tips are always appreciated.

Hello everyone i have an issue with this test-code:

-- Setze globale Parameter-Variable
var params CLOB;

begin
  :params := '
  {
    "provider"       : "openai",
    "credential_name": "litellm",
    "url"            : "http://litellm.devki.com:4000/v1/embeddings",
    "model"          : "text-embedding-3-large"
  }';
end;
/

-- Test per PL/SQL
declare
  input clob;
  v vector;
begin
  input := 'Hello world';

  v := dbms_vector_chain.utl_to_embedding(input, json(:params));
  dbms_output.put_line(vector_serialize(v));
end;
/

-- Test per SQL
select vector_serialize(
  dbms_vector_chain.utl_to_embedding('Hello world', json(:params))) from dual;

it always said credential not exists but in my remote-server credentials it’s exists. Is there a problem with own hosted LLMs. I’m in a closed network without internet access!

I've heard that APEX Autonomous Database has limits per CPU for # of concurrent users. Does anyone know what those limits are? If I have 2000 users, how many extra CPU's do I need?

Hello Everyone, If we are hosting python application on OCI, then how to use Devops with the SCM and CI/CD pipeline applicable between OCI and APEX. Does anyone implemented this in your projects?? Kindly suggest!

How can i force CSV downloads to be UTF-8? Apex 23.2

Hi guys, I'm working on excel upload functionality. But I have 2 tabs in my excel, how do I upload data from both tabs?

Post Calculation Computation - I used this in apex 5 to update a "Display Only" item to change a user ID to a Display Name (via function call in an expression). Now it's deprecated and not available for new items in Apex. I see a recommendation to replace it with a computation, but I can't get it to update the displayed value on page load no matter what execution point i use. It seems to me the only way to replicate the PCC functionality is to have two items, one hidden that has the value sourced from the database, and the other a Display Only item with the value calculated from the first item. This is obliviously worse then using a single item with PCC. Is there a better way to do this?

hello All, Can someone please tell me what is wrong with this reference to the page item P600_COLUMN_TO_SHOW in this code? The query is for a simple classic report region, PLSQL function body returning SQL. That Item contains the columns to use in the query. If I hardcode it works but if I use v() function it doesn't work. Apex 19.2

@Jayson Hanes - Oracle APEX PM thx for the hint seems good :slightly_smiling_face:

note from Dev on this

There is no reason for it. You can workaround this bug by using apex_application_admin.set_remote_server(). bug # 37689711

Cloud databases cannot make HTTP requests, only HTTPS ones

Yes

Hi @Andi Oberhauser , your database is probably autonomous transaction from cloud right?

Hello everyone - I have a simple bug. When I create a Vector Provider I always get the error that the base url have to start with HTTP or HTTPS. When I use https it works with http not. But in my environment I need HTTP! Any ideas?

:rocket: Introducing MC CHATBOT - AskAssist for Oracle APEX :brain::speech_balloon: I’m excited to share my latest APEX plugin: MC CHATBOT - AskAssist – a smart, predefined Q&A chatbot built for Oracle APEX with a modern UI/UX. :small_blue_diamond: Key Features: Predefined main questions, sub-questions, and answers Dynamic Ajax-powered response system Seamless integration with Oracle APEX Clean, responsive UI for great user experience Ideal for FAQs, onboarding, lead qualification, and guided user flows :link: GitHub Repository: :point_right: https://github.com/mishab424/MC-CHATBOT---AskAssist :dart: Live Demo: :point_right: Launch Demo :wrench: Easy to install and customize – just import the plugin, create tables, and plug it into your APEX page! Feel free to try it out and let me know your thoughts or suggestions! :envelope_with_arrow: For customization or enterprise use, contact me on or at

:newspaper:The August issue of APEX Newsletter is live! Read the latest updates, new ACE series, community posts, and much more! apex.oracle.com/go/august-2025 #orclAPEX #LowCode

Hi, hello everyone! I look forward to learning Oracle APEX. Please guide me in learning it and suggest some free online resources

:wave: Hi everyone, I'm Richard, an Oracle APEX developer from Slovakia. I work mainly with APEX and PL/SQL, and lately I've been trying to be more active in the community. Looking forward to learning from you all and contributing where I can!

Is there any plug-in or process or way to compress images before upload ?

In OCI, does anybody know if ATP (APEX workload type) can be used with Oracle Data Safe?

clicking "Publish" for MLS Translate receiving below error. Where can I see the log in *autonomous* for the issue? Uploaded XLF file and "Apply checked". Next when clicked "Publish" getting error. This is working on simple application with one page. But failing on our real client application. Appreciate any clue.

Hi, With Interactive Grid is there a way to toggle row selection behaviour from multiple (checkbox) and single (radio field) at runtime? Thanks

Hello We need to update our authentication method to use *OpenID Connect (OIDC)* with *Proof Key for Code Exchange (PKCE)* to enhance security and compliance. Has anyone implemented this already or explored potential workarounds? I'd love to hear your thoughts or experiences on: • Integrating OIDC with PKCE into APEX apps • Handling token exchange securely • Tips or resources to get started Any ideas, documentation links, or working examples would be greatly appreciated. Let’s collaborate to get this set up smoothly! :raised_hands: Thx

I have APEX version 22.2 and I'm working with SQLcl to deploy applications. **Problem**: When I deploy an APEX application using SQLcl and run the fXXX.sql file, I have no way to programmatically set the Parsing Schema. The application always defaults to the first schema in the workspace schema list, but I need it to use a specific schema. Is there an API or installation parameter that controls this setting? Thanks! ????

Hi, has anyone also had the problem that the icons in APEX disappeared? It looks like this for me, also in different browsers.

Hi guys, is it possible to expand collapse the desktop navigation entry by clicking the whole label, I am able to do that only by clicking the small arrow, but not the whole row or label. It’s Universal Theme.

Hi team, When I use apex_error in process it shows error message on page. How do I hide *"1 error has occurred" that comes along with my error message for* APEX_ERROR.ADD_ERROR(p_message => 'Your password has expired. Please reset your password.', p_display_location => APEX_ERROR.c_inline_in_notification); I use Inline CSS but didn't work. .a-Notification-title.aErrMsgTitle { display: none !important; }

Hoping someone can help me with something. I have a table that has 9 different columns that are all a 1 character varchar. I want to put them all into a checkbox group. This query will get the things I want to change in a single checkbox group. Just so you can see where I'm starting from. select CB_ITEM_1, CB_ITEM_2, CB_ITEM_3, CB_ITEM_4, CB_ITEM_5, CB_ITEM_6, CB_ITEM_7, CB_ITEM_8, CB_ITEM_9, from PARTS_CATALOG where PART_NUMBER = P350_ID What I want is a single row of these nine fields where I can turn any one of them, or all of them on or off. I am not familiar with using a Checkbox Group, can they even be used to change multiple values from a single row in a table? I don't want to create 9 separate checkboxes if I can do it all in a single checkbox group.

Hello everyone. I am working an API that uses bearer token autentication. i am using this test block: DECLARE l_token VARCHAR2(4000); l_response CLOB; BEGIN l_token := '{TOKEN}' ; apex_web_service.g_request_headers(1).name := 'Authorization'; apex_web_service.g_request_headers(1).value := 'Bearer ' || l_token; apex_web_service.g_request_headers(2).name := 'Content-Type'; apex_web_service.g_request_headers(2).value := 'application/json'; l_response := apex_web_service.make_rest_request( p_url => 'url', p_http_method => 'GET' ); DBMS_OUTPUT.put_line(l_response); END; Iam able to que get the response, manually generating the token from outside the database using a python script that receive: an userid, a private key file and return the token. I can not find anywhere how to handle token renewal from within apex (plsql). Asked AI and is suggesting create a micro service for the python script that returns de token. also suggested to user apex_Jwt api, but that didnt worked out. Does anyone knows o help find how to integrate apex with those apis that uses beater tokens (clientid and private key) only

We are a team of developers working on multiple applications in Oracle APEX, version 22. All of us are working on the same application, which makes it very difficult to deploy the application to the client, as everyone is dependent on each other's changes. one idea we are considering is separating the various applications into smaller ones, with each page in its own application, while maintaining a single authentication system. Currently, we also have some applications with a unified authentication system, so we are exploring the best way to manage multiple applications with a single authentication setup." what you think about it have you else approch ?and what is disadvantages? Thank you

Hello I have OCI autonomous db with APEX and have EBS as well in same OCI apps/apps@ebsdb my requirement is that I want to use ebs schema objects in my OCI autonomous database for APEX to show and create some reports so how to do that?

Hello, what might be the reason that a vendor API doesn't return the relevant cookie when using APEX_WEB_SERVICE but return it when using postman? The response code is 200 both in postman and APEX_WEB_SERVICE.

I have a question regarding APEX Dashboard I want to export my dashboard into pdf in Oracle APEX Kindly anybody guides me regarding this I do not want to use any external report such BI publisher and APEX office print, Jasper Reports any other solution for this

How do we make AI “chat requests” performant in APEX ? It seems that each RAG source (SQL) that is added, increases the overall response time. Is there anyway to see which RAG sources are actually firing behind the scenes (metrics etc). Thanks

btw, i don't know why i haven't run into this issue before with APEX. Users have just started spamming the "save" button for some reason??

APEX 23.2 - "Debounce" page submission. I don't see a declarative way to do this? Seems the fix is to have the button action be DA, then disable the button as the first true action followed by "submit" with the button name.

Hi everyone Today chrome decided to completely disable the plug in *APEX Page Designer Tab Lock - Explorer UK* from @Matt Mulvaney Does anyone know what is the replacement? If there is. Also the *FOEX Developer Addon plug* in has been marked to be disabled in the future. Same question.. anyone know what is the replacement? Thanks!

Way back when APEX included a “Forms to APEX” migration functionality. You could upload Forms XML files into tables and use that info to start a migration. The “automated” migration didn’t deliver a good result, but I am looking for the part that reads those XML files into tables, so I can easily see what is in there and keep track of what is migrated / needs to be migrated / can be discarded. Is there a (relatively) simple APEX app out there that still does that trick - or something similar?

#_general How to enable email functionality between our Oracle applications and Microsoft Exchange (Office 365) email server.? Need to configure OAUTH.

We are using APEX 24.2 on Autonomous Database 19c. Only Autonomous Database 23ai has the native vector capabilities. In our current applications we are using AI assistants, but the token use is so large. Is there any other (non-native) way to use vectors in 19c database so we don't use so many tokens?

Help me out. What is the blog aggregator website that is presented every year at KSCOPE? Now using AI.

Does anybody know that how to integrate Oracle APEX OCI instance means database with EBS on cloud we want to use database of EBS database on cloud?

Does anybody know whether there is an API function to replace substitutions and template directives like apex.util.applyTemplate(pTemplate, pOptions_opt_) for PL/SQL? I know about apex_plugin_util.replace_substitutions. Not sure whether it will deal with template directives as well.

I could really use som help with custom headings on a classic report. I'm going crazy and have been chaos monkey trying things for a few hours now. It seems like I can't set heading on my last two columns!? The number of columns is not 100% correct in the pictures but since SMSF is visible i expect "Should be visible" to show up in the next column. Any ideas on what is going on?

:newspaper:* The APEX July issue is live!* Recognition & certification updates, events & more inside!

is there a method to submit a display only page items ? without triggering the Session state protection violation error ?

Hi all. I had a query regarding opening a modal dialog when i click on the value of a page item. How can i achieve that? If someone can guide here? Thanks.

I'm seeing an error message in js console: Refused to display <host> in a frame because it set 'X-Frame-Options' to 'deny'.

This no longer works under 23.2, how should this be done now?

I have a modal within a modal within a modal. Under apex 5 we could close all these and load a different parent page from a link by setting the link target to: javascript:apex.navigation.dialog.close(true,'');apex.navigation.dialog.close(true,'f?p=101:1:::NO::param:value);"