I've been struggling with modal dialog stretching & zooming. A user likes to run the app on 1/2 of their screen and complains about how words start escaping their bounds. Like the words in buttons spilling out of the button, or adding a line-feed. I have told them to shrink the size of the window running the app on their desktop and then zoom in or out with the Chrome zoom function. That works just fine for me but I was wonder what other developers do to address this? I'm totally guessing, but is it common practice to put the *col-xxs-12* on an entire modal dialog, or on every one of the regions (assuming that all are 12 columns wide) inside the form? Is there some setting that tells Chrome to change the font size based on the screen size, or something like that? I'm not using any fixed font sizes. I'm just using default, larger, x-large and xx-large all over my app. What is common practice in this regard?

After 10 years I couldn't find anything @maxime_tremblay coulnd't fix, I'm running out of time :grimacing::relieved::sweat_smile:

We are back in business @maxime_tremblay fixed it. We ran out of space, because the Audit Trail reached 6+ Gig. He moved the data file, changed the location of the config. Deleted the old file and reclaimed the space of the new table space. Or something like that :smile:

We have issues with apex.world, we are working on it, it's a new error, didn't go away even after restarting everything. We let you know. Slack is not affected though

Greetings everyone , have anyone tried to integrate OpenAI API with oracle apex workspace for Ai assistant chat to help in Sql builder and page designer ?

Hi all, Is there a way to add a timeout to HTTP request from PL/SQL? Oracle 10g Enterprise Edition. I googled, and it said I should use UTL_HTTP.set_transfer_timeout(l_req, 15); but it doesn't work..

Is there a setting someplace where I can tell my application to record the size of my modal dialog pages? So if I open a modal dialog and i resize it I'd like that to be the same the next time I open that same modal dialog page. There must be a global setting for this somewhere, right? if not then how is that done for every modal dialog in my app? Especially since the majority of my pages are Modal Dialog.

Hoping someone has a clue on this one. I have an App that I've been developing for quite a while. I stood up a new schema the other day and I built a copy of my app. I built all the tables with a DDL script in the new schema and populated the tables I need for the app to run in a "brand new deployment" manner. It runs just fine and the setup was pretty uneventful. So then I returned to my development schema and made some changes to a page that didn't work out so well. So I thought I'd just pull back the page from my fresh schema I created just two days ago. So I logged into my dev schema and I deleted the page in question. (Yea, I know, I should have made a copy). From my new schema I exported the page I need and now I'm attempting to import it into my dev schema, and I get a pretty hard error. I'm not expecting anyone to fix this, but I have no clue where to even look for the error that's causing it. My Oracle APEX programming interface completely freaks out. It's the same app, and I'm just pulling back a single page. Does anyone have a clue why that might not work, it sure seems like a basic thing for me to do, no?

does it bug anybody else that ideas get closed and probably never looked at again? I've seen several with "good idea, but we can't right now". just feels like it's getting thrown in the recycling bin with the rest of the failures

Apex 23.2. A classic report with a blob download. Was working under 5.1, I can't be sure anyone has used this since we upgraded to 23.2, but now some of the links work and some don't, instead I see the following in the "downloads" in chrome:

QCI specific question. Anyone have any insight on a Always Free DB That is failing to start up again?

Hummm interesting. OK I'll ignore that one. Thanks so much.

I'm hoping someone can get me pointed in the right direction here. I am seeing JS errors about a deprecated feature being used, looks like an unload listener, but I have no idea what I'm talking about here. Is this a known thing and is there a fix for it?

Have you ever created a Heat Map in APEX? How feasible is this using Oracle JET? I’ve been trying to do it by modifying a Scatter Chart, but without success. Thank you. https://www.oracle.com/webfolder/technetwork/jet/jetCookbook.html?component=dataCollections&demo=heatmapGrid

When I create a workspace on OCI, it creates 2 schemas (eg: WS and WKSP_WS) and wksp_ws becomes the parsing schema with all the privileges and objects. The WS does not have any privileges or objects. What is the purpose of this WS schema, is ti required and can it be dropped without breaking anything? What is the role of APEX_PUBLIC_USER and APEX_PUBLIC_ROUTER? Are these used for impersonation in the 3-tier architecture and routing requests? Which schema gets used at runtime for DML? Is wksp_ws used only at design time in the builder for DML and DDL?

I’ve blocked access to the APEX Builder using the following commands:

apex_instance_admin.set_parameter('DISABLE_WORKSPACE_LOGIN','Y'); 
apex_instance_admin.set_parameter('DISABLE_ADMIN_LOGIN','Y');

However, I can still access the page at https://localhost/ords/f?p=4550:7 on APEX 21.2.9 How to completely prevent access to this page without having to restrict the path at the web server level?

Is there a way to make a typical text field un-editable but not disable the double click DA on the field. I've tried setting the field to read-only and I've tried : document.getElementById("P126_CREATED_DATE").readOnly = true; as page load JS code. These do prevent editing, but they also make the double click DA I have on the field not work as well. So I'm wondering if there is some other option I could use?

I was wondering, I have a page where I'm calling other pages using a button. All that works perfectly but when I close the called page I execute some DAS's. Is there any way to know which page I'm returning from? So I hit one button and I open Page 7 and then return. I hit a different button and I that opens page 41. Is there a way to trigger a DA based on the page I returned from? So if I come back from P7 a DA fires, but if i come back from P41 a different DA fires. Is this possible? Is there some hidden variable that contains the page I just returned from?

Hi team, I’m currently in a pickle. 1)I need to take a screenshot of the entire screen and convert it to a PDF. 2)Store the PDF in a table and send it as an email attachment. In one process or say on click of one button I can handle the second part, but does anyone have an idea how to achieve the first part?

Please let me know about UI/UX resources.

I'm sure it's just me, right? But I want a button that floats over my page that has a bunch of tabs in it. So, like a normal human I ask Copilot how to do that. I ask "How do I create a floating button in Oracle APEX?" and Copilot responds with this... So I try it and there is no position of "Floating or Inline with template" that I can place my button into anywhere in the APEX application builder. Sometimes I really have to wonder about these research services that claim to be so wonderful. It just tells me what it thinks I want, the fact that what it tells me is absolute non-sense doesn't seem to matter much. Was this option EVER true? I want a button on the side of my page that will show no matter what tab I'm on, I hit that button and it opens a region while passing the tab name I was on when I hit the button. Both questions I asked of Copilot came back with useless and fundamentally wrong answers. The bots will be the last thing left alive after the robot invasion. Skynet has arrived. Earlier I asked Copilot for how to tell which tab the user is on and it said "Sure just use the *:TAB_NAME* variable". The fact that the :TAB_NAME variable does not exist seems to be irrelevant.

Apex 23.2 We have a bunch of interactive reports that have grown and gotten to slow to be run in real time. We have done various things to speed up the run time but I think some of them need to be turned into a background job with a download of the resultant data somewhere. Is there are "shortcut" to turning a IR into a background job?

I was wondering about something. I have an on-screen variable that is a file upload type. It is set to use the APEX_APPLICATION_TEMP_FILES as the storage. But I have a feeling that some action needs to take place to get it actually written into that table. I never see my file in there. Is there a DA of some sort that I need to run to actually store the file in there?

Hello everyone, I am trying to change the decimal separator from a comma to a period in a translated French application (fr-ca). I am using the following code in an application process _On Load: Before Header_:

DBMS_SESSION.SET_NLS('NLS_NUMERIC_CHARACTERS', '''.,''');

However, I receive an error when running the French version of the application (see image below). Does anyone have an idea of how I can resolve this issue? _Note: It works correctly when French is set as the application’s primary language, but not when it is a translated application._ Apex Version: 24.1.3

Is there a way to set a name on these columns? I mean, to display a name inside the bars. I’ve been experimenting with the Custom Column attributes and the Initialization JavaScript Function, but without success, but the way the name of the serie is the text that I want inside the bar. select ..... '{"customText":" '|| name || '"}' as custom_column from table ....

Hello, I'm trying to get a session ID in OCI AUtonomous Database environnement but I don't have enough privilege Any idea how i can do that ? select * from APEX_240200.wwv_flow_sessions$ ; grant select on apex_240200.wwv_flow_sessions$ to myuser;

Is it possible to use APEX's mapping features completely offline, or do the tiles require some internet connectivity? If it is feasible, can someone point me to documentation for this?

It seems like the "option" etc calls are not having any effect whatsoever. I'm certain the selector is correct as it returns the datepicker object

I've tried various methods as documented in the jqueryui docs with no effect. $( ".selector" ).datepicker( "option", "maxDate", "+7d" ); $( ".selector" ).datepicker("refresh") etc

How can i dynamically set the max/min date in a datepicker in apex 23.2+ ?

Hi all, I am trying to run a procedure, and keep receiving error in the dynamic SQL. I am just showing here the part of code which is having issue:

  v_insert_sql := 'INSERT /*+ parallel(4) enable_parallel_dml */
                             INTO CALL_ARCHIVED_FETCHED
                             (call_date, connect_time, calling_number, called_number,
                              entry_tg, exit_tg, duration)
                             SELECT * FROM (
                                 SELECT call_date,
                                        new_ani          AS calling_number,
                                        called_number
                                 FROM ' || v_table_name || '
                                 WHERE call_date BETWEEN :1 AND :2
                                   AND egress_duration > 0
                                   AND (plat_entry_point LIKE ''%'' || :3 || ''%''
                                        OR plat_exit_point LIKE ''%'' || :3 || ''%'')
                                   AND SUBSTR(cost_error_code, 1, 3) LIKE ''%E''
                                   AND (called_number LIKE ''%'' || :4
                                        OR new_ani LIKE ''%'' || :4 || ''%'')';
            IF v_limit IS NOT NULL THEN
                v_insert_sql := v_insert_sql || ' AND ROWNUM <= ' || v_limit;
            END IF;
            v_insert_sql := v_insert_sql || ')';

            -- Enable parallel DML
            EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';

            -- Execute insert
            EXECUTE IMMEDIATE v_insert_sql
                USING p_start_date, p_end_date, p_tg_filter, p_number;

            v_rows := SQL%ROWCOUNT;

I changed to this thinking maybe the issue is the date column into :1 and :2 bind variable but still same issue:

    FROM ' || v_table_name || '
                     WHERE call_date BETWEEN TO_DATE(:1, ''YYYY-MM-DD'')
                                         AND TO_DATE(:2, ''YYYY-MM-DD'')
                       AND egress_duration > 0
                       AND (plat_entry_point LIKE ''%'' || :3 || ''%''
                            OR plat_exit_point LIKE ''%'' || :3 || ''%'')
                       AND SUBSTR(cost_error_code, 1, 3) LIKE ''%E''
                       AND (called_number LIKE ''%'' || :4
                            OR new_ani LIKE ''%'' || :4 || ''%'')';

IF v_limit IS NOT NULL THEN
    v_insert_sql := v_insert_sql || ' AND ROWNUM <= :5';
END IF;

v_insert_sql := v_insert_sql || ')';

-- Now pass dates as strings
IF v_limit IS NOT NULL THEN
    EXECUTE IMMEDIATE v_insert_sql
        USING TO_CHAR(p_start_date,'YYYY-MM-DD'),
              TO_CHAR(p_end_date,'YYYY-MM-DD'),
              p_tg_filter,
              p_number,
              v_limit;
ELSE
    EXECUTE IMMEDIATE v_insert_sql
        USING TO_CHAR(p_start_date,'YYYY-MM-DD'),
              TO_CHAR(p_end_date,'YYYY-MM-DD'),
              p_tg_filter,
              p_number;
END IF;

I can provide full code if needed... Thanks Any idea ?

Hi anytime the IT is working on the Server there is no access to database and this message displays to Apex users. We are thinking of redirecting the page to another simple HTML Page with customized Message to end User. It should surely be done in the HTTP / Application Server. Any idea how to handle that?

Hi all experts, Quick context: We are pushing some file from our local server to Prod Server and we need to read the number of rows in the file, on the destination folder, and compare against the original file, in order to make sure file was not corrupted along the way: So I found this function that can get the size of the file in the remote server, but I need to know the total records in the file. Does someone know how to do that or modify this function to read the row count instead of the file size?

CREATE OR REPLACE FUNCTION CIFUTILS.FileSizedev (
    HostIP     VARCHAR2,
    PortNo     VARCHAR2,
    UserName   VARCHAR2,
    Pass       VARCHAR2,
    Dir        VARCHAR2,
    FileName   VARCHAR2
) 
RETURN NUMBER
IS
    oConn        UTL_TCP.connection;
    pList        CIFUTILS.ftp.t_string_table;
    vFileFound   BOOLEAN;
    vFilesize    VARCHAR2(100);
    vFound       BOOLEAN;
    vFin         NUMBER;
    vIni         NUMBER;
    vRet         NUMBER;

BEGIN
    -- Initialize flag
    vFound := FALSE;

    BEGIN
        -- Login to FTP server
        oConn := CIFUTILS.FTP.login (
            p_host    => HostIP,
            p_port    => PortNo,
            p_user    => UserName,
            p_pass    => Pass,
            p_timeout => 100
        );

        -- List files in the directory
        FTP.list(oConn, Dir, pList);

        -- Logout from FTP server
        CIFUTILS.FTP.logout(oConn, FALSE);

        -- Search for the file in the directory listing
        FOR j IN 1..pList.count LOOP
            IF INSTR(pList(j), FileName, 1) <> 0 THEN
                vFileFound := TRUE;
                vFin := INSTR(pList(j), FileName, 1) - 2;

                -- Find the starting position of the file size in the string
                FOR i IN REVERSE 1..vFin LOOP
                    IF SUBSTR(pList(j), i, 1) = ' ' THEN
                        vIni := i;
                        EXIT;
                    END IF;
                END LOOP;

                -- Extract the file size
                vFilesize := SUBSTR(pList(j), vIni, vFin - vIni + 1);
                EXIT;
            END IF;
        END LOOP;

        -- Return the file size or -1 if file is not found
        IF vFileFound THEN
            vRet := TO_NUMBER(TRIM(vFilesize));
        ELSE
            vRet := -1;
        END IF;

    EXCEPTION
        WHEN OTHERS THEN
            -- Handle different error codes using CASE statement
            CASE SQLCODE
                WHEN -29260 THEN
                    vRet := -2;
                WHEN -29276 THEN
                    vRet := -3;
                WHEN -20000 THEN
                    vRet := -4;
                ELSE
                    RAISE;
            END CASE;

    END;

    -- Return the result
    RETURN vRet;

END;
/

Any advice on good Apex books? The ones I have found are all from around 2020, and a lot seems to have changed since then :)

Hello, if there is any internship remote opportunities, please let me know. It will help me start my career.

Dear all l have an interactive report with all the formats of the files like doc,docx,xlsx,pdf..etc By clicking on document name can show the documents in popup page or another region? If yes can you please suggest something it would be great help.. thanks in advance

My application is configured as a friendly URL; I have a redirect in a "Before header" process on a page. How do I configure the SQL link? This syntax doesn't work. I have a blank page with the redirect page alias in the address. DECLARE l_page NUMBER; l_alias_p VARCHAR2(200); l_url VARCHAR2(4000); BEGIN l_page := 48; SELECT LOWER(NVL(page_alias, page_id)) INTO l_alias_p FROM apex_application_pages WHERE application_id = :APP_ID AND page_id = l_page; l_url := apex_page.get_url( p_application => :APP_ID, p_page_alias => l_alias_p, p_session => :APP_SESSION ); htp.init; owa_util.redirect_url(l_url); apex_application.stop_apex_engine; END;

Oracle managed ORDS using APEX service on 24.2.8 in OCI. What could cause the APEX shortcut to be disabled? If I navigate to APEX builder directly with the URL it loads fine. If I refresh this page a bunch, sometimes it'll be enabled.

Hello all, how to deploy the application in Apex, is it free of cost, or how much in INR?

I wonder if anyone can tell me how to make this button a different color or just apply the t-Button--hot class to it? This is a typical Date and time popup. When I try to change the button settings in the Theme Roller any change I make changes every button in my app in a way that doesn't make any sense. Can anyone tell me how to target just this one button to make it hot? Or to make it any other colour I might like? I'd be happy with just making it t-Button--hot if it's easy.

apex.world

Hi all, I have to work on a code that someone else has developed. It is difficult to follow the if...end if, in short, the blocks of code are not clearly defined. Is there a text editor that does proper indentation of the code? I mean a sort of code beautifier. I found beautifier for json, xml, etc but not for plsql

Apex 23.2 APEX_ACTIVITY_LOG has no data. I have logging turned on at app and workspace instance level. However, APEX_WORKSPACE_ACTIVITY_LOG does have data. Is this equivalent?

When I add dynamic link in interactive report and download through action menu but in downloaded excel file the dynamic link code show up not that link main word I don't want logic in report I want only value

Hi everyone, I need some advice. I've been trying to build this Gantt (screen 1) using Gantt Chart Pro, but I'm not sure if it's possible or if there's an alternative solution. I managed to create this (screen 2), but it’s not even close to what I want. As soon as I modify the Task Name, it also changes the LABEL under Project 1 as well as what appears inside the Gantt. I tried using JavaScript, but I didn’t get any satisfactory results. Thank you for any help.

Please suggest the best Apex developer tutorials on YouTube.

I am configuring OCI Email Delivery for an APEX application I am developing in my Always-Free Autonomous Database. I am using a Custom Authentication scheme and the users in my APEX application are defined in a *database table only* with authorization schemes also running from there. I am following the guidelines from Configure OCI Email Delivery. Looking at creating SMTP credentials, it seems as if I will need to create a User in the OCI console for every user in my application that needs the ability to send an email. 1. Am I reading this correctly? Is there a way to avoid this? 2. If this is the only way to go about this, what other privileges will this OCI user be granted in my application / OCI interface etc. that I need to look out for. Thanks!

Hello, can someone please guide if there is a way to have a date-picker for months and years only in Apex 21.2?

Do folks use apex_util.set_session_state or apex_session_state.set_value? for a simple varchar2 it seems the same, and has always confused me why there's two options

I have an APEX question that will open up a LOT of cans of worms.. Its to possible move towards using APEX to build a CI/CD process to replace a rather convoluted manual process when migrating objects (APEX apps, pl/sql scripts, PL/Sql Packages) from SVN (possible git-lab in future) into higher environments (Devl => Test => Formal Test => Prod).. This I know would entail at a minimum using Jenkins and other software which is why I am asking here.. Has anyone every tried build an APP to handle this with a workflow to handle user approval when required?