oracle / apex Goto Github PK

UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****
UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****

I am running on oracle oci cloud Application Express 21.1.7

possibly the issue is with the call to
https://gd49ef7d5e3cd2d-db202110212330.adb.us-phoenix-1.oraclecloudapps.com/ords/wwv_flow.accept

When I run the local rest data "load data", I get
ORA-01031: insufficient privileges

Contact your application administrator. Details about this incident are available via debug id "57028".
Technical Info (only visible for developers)

UPDATES: *********** ISSUE FIX BY REMOVEING PROXY IN APP DEFINITIONS LEFT THERE FROM APEX.ORACLE.COM USAGE*****

User

Page

DateDescending
ORA-01031: insufficient privileges Contact your application administrator. Details about this incident are available via debug id "57030". APLASCENCIA 11 69 seconds ago
APEX - ORA-01031: insufficient privileges - Contact your application administrator. Details about this incident are available via debug id "57029". ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1384 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1419 APLASCENCIA 2 96 seconds ago
APEX - ORA-01031: insufficient privileges - Contact your application administrator. Details about this incident are available via debug id "57028". ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1384 ORA-06512: at "APEX_210100.WWV_FLOW_ERROR", line 1419

is_internal_error: false
ora_sqlcode: -1031
ora_sqlerrm: ORA-01031: insufficient privileges ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 56 

ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1157 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 757 ORA-06512: at "SYS.UTL_HTTP", line 20 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 728 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 998 ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1346 ORA-06512: at "APEX_210100.WWV_FLOW_WEBSERVICES_API", line 604 ORA-06512: at line 5 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682 ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 330 ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 394 ORA-06512: at "APEX_210100.WWV_FLOW_EXEC_LOCAL", line 2880 ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4434 ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4470 ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 35 ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 1116 ORA-06512: at "APEX_210100.WWV_FLOW_PLUGIN", line 2784
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 1934813666072611847
component.name: Fetch data into Collection
error_backtrace:

ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 757
ORA-06512: at "SYS.UTL_HTTP", line 20
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 728
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 998
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_210100.WWV_FLOW_WEBSERVICES_API", line 604
ORA-06512: at line 5
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 56
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2387
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 757
ORA-06512: at "SYS.UTL_HTTP", line 20
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 728
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 998
ORA-06512: at "APEX_210100.WWV_FLOW_WEB_SERVICES", line 1346
ORA-06512: at "APEX_210100.WWV_FLOW_WEBSERVICES_API", line 604
ORA-06512: at line 5
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_210100", line 682
ORA-06512: at "APEX_210100.WWV_FLOW_DYNAMIC_EXEC", line 2348
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_210100.WWV_FLOW_CODE_EXEC", line 394
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC_LOCAL", line 2880
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4434
ORA-06512: at "APEX_210100.WWV_FLOW_EXEC", line 4470
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 35
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS_NATIVE", line 1116
ORA-06512: at "APEX_210100.WWV_FLOW_PLUGIN", line 2784
ORA-06512: at "APEX_210100.WWV_FLOW_PROCESS", line 203

error_statement:

begin declare
    l_response clob;
begin
    -- load REST response into a collection
    l_response := apex_web_service.make_rest_request(
        p_url              => :SAMPLE_ENDPOINT_URL,
        p_http_method      => 'GET');

    apex_collection.create_or_truncate_collection( 'REST_COLLECTION' );
    apex_collection.add_member(
        p_collection_name => 'REST_COLLECTION',
        p_clob001 =>         l_response );
end;
end;

----------- here is the acl's -------------
CREATE OR REPLACE EDITIONABLE PROCEDURE "ADMIN"."SHOW_ACLS" AS
--DECLARE
l_last_acl dba_network_acls.acl%TYPE := '';
l_last_principal dba_network_acl_privileges.principal%TYPE := '';
l_last_privilege dba_network_acl_privileges.privilege%TYPE := '';
l_last_host dba_network_acls.host%TYPE := '';

FUNCTION get_timestamp (p_timestamp IN TIMESTAMP WITH TIME ZONE)
RETURN VARCHAR2
AS
l_return VARCHAR2(32767);
BEGIN
IF p_timestamp IS NULL THEN
RETURN 'NULL';
END IF;
RETURN 'TO_TIMESTAMP_TZ(''' || TO_CHAR(p_timestamp, 'DD-MON-YYYY HH24:MI:SS.FF TZH:TZM') || ''',''DD-MON-YYYY HH24:MI:SS.FF TZH:TZM'')';
END;
BEGIN
FOR i IN (SELECT a.acl,
a.host,
a.lower_port,
a.upper_port,
b.principal,
b.privilege,
b.is_grant,
b.start_date,
b.end_date
FROM dba_network_acls a
JOIN dba_network_acl_privileges b ON a.acl = b.acl
ORDER BY a.acl, a.host, a.lower_port, a.upper_port)
LOOP
IF l_last_acl <> i.acl THEN
-- First time we've seen this ACL, so create a new one.
l_last_host := '~';

  DBMS_OUTPUT.put_line('-- -------------------------------------------------');
  DBMS_OUTPUT.put_line('-- ' || i.acl);
  DBMS_OUTPUT.put_line('-- -------------------------------------------------');
  DBMS_OUTPUT.put_line('BEGIN');
  DBMS_OUTPUT.put_line('  DBMS_NETWORK_ACL_ADMIN.drop_acl (');
  DBMS_OUTPUT.put_line('    acl          => ''' || i.acl || ''');');
  DBMS_OUTPUT.put_line('  COMMIT;');
  DBMS_OUTPUT.put_line('END;');
  DBMS_OUTPUT.put_line('/');
  DBMS_OUTPUT.put_line(' ');
  DBMS_OUTPUT.put_line('BEGIN');
  DBMS_OUTPUT.put_line('  DBMS_NETWORK_ACL_ADMIN.create_acl (');
  DBMS_OUTPUT.put_line('    acl          => ''' || i.acl || ''',');
  DBMS_OUTPUT.put_line('    description  => ''' || i.acl || ''',');
  DBMS_OUTPUT.put_line('    principal    => ''' || i.principal || ''',');
  DBMS_OUTPUT.put_line('    is_grant     => ' || i.is_grant || ',');
  DBMS_OUTPUT.put_line('    privilege    => ''' || i.privilege || ''',');
  DBMS_OUTPUT.put_line('    start_date   => ' || get_timestamp(i.start_date) || ',');
  DBMS_OUTPUT.put_line('    end_date     => ' || get_timestamp(i.end_date) || ');');
  DBMS_OUTPUT.put_line('  COMMIT;');
  DBMS_OUTPUT.put_line('END;');
  DBMS_OUTPUT.put_line('/');
  DBMS_OUTPUT.put_line(' ');
  l_last_acl := i.acl;
  l_last_principal := i.principal;
  l_last_privilege := i.privilege;
END IF;

IF l_last_principal <> i.principal 
OR (l_last_principal = i.principal AND l_last_privilege <> i.privilege) THEN
  -- Add another principal to an existing ACL.
  DBMS_OUTPUT.put_line('BEGIN');
  DBMS_OUTPUT.put_line('  DBMS_NETWORK_ACL_ADMIN.add_privilege (');
  DBMS_OUTPUT.put_line('    acl       => ''' || i.acl || ''',');
  DBMS_OUTPUT.put_line('    principal => ''' || i.principal || ''',');
  DBMS_OUTPUT.put_line('    is_grant  => ' || i.is_grant || ',');
  DBMS_OUTPUT.put_line('    privilege => ''' || i.privilege || ''',');
  DBMS_OUTPUT.put_line('    start_date   => ' || get_timestamp(i.start_date) || ',');
  DBMS_OUTPUT.put_line('    end_date     => ' || get_timestamp(i.end_date) || ');');
  DBMS_OUTPUT.put_line('  COMMIT;');
  DBMS_OUTPUT.put_line('END;');
  DBMS_OUTPUT.put_line('/');
  DBMS_OUTPUT.put_line(' ');
  l_last_principal := i.principal;
  l_last_privilege := i.privilege;
END IF;

IF l_last_host <> i.host||':'||i.lower_port||':'||i.upper_port THEN
  DBMS_OUTPUT.put_line('BEGIN');
  DBMS_OUTPUT.put_line('  DBMS_NETWORK_ACL_ADMIN.assign_acl (');
  DBMS_OUTPUT.put_line('    acl         => ''' || i.acl || ''',');
  DBMS_OUTPUT.put_line('    host        => ''' || i.host || ''',');
  DBMS_OUTPUT.put_line('    lower_port  => ' || NVL(TO_CHAR(i.lower_port),'NULL') || ',');
  DBMS_OUTPUT.put_line('    upper_port  => ' || NVL(TO_CHAR(i.upper_port),'NULL') || ');');
  DBMS_OUTPUT.put_line('  COMMIT;');
  DBMS_OUTPUT.put_line('END;');
  DBMS_OUTPUT.put_line('/');
  DBMS_OUTPUT.put_line(' ');
  l_last_host := i.host||':'||i.lower_port||':'||i.upper_port;
END IF;

END LOOP;
END;
/

-- /sys/acls/apex21_MISO_open_acl_file.xml

BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => '/sys/acls/apex21_MISO_open_acl_file.xml');
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => '/sys/acls/apex21_MISO_open_acl_file.xml',
description => '/sys/acls/apex21_MISO_open_acl_file.xml',
principal => 'APEX_210100',
is_grant => true,
privilege => 'connect',
start_date => TO_TIMESTAMP_TZ('10-FEB-2022 19:17:27.087684000
+00:00','DD-MON-YYYY HH24:MI:SS.FF TZH:TZM'),
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => '/sys/acls/apex21_MISO_open_acl_file.xml',
host => '*',
lower_port => 1,
upper_port => 9999);
COMMIT;
END;
/

-- NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394

BEGIN
DBMS_NETWORK_ACL_ADMIN.drop_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394');
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.create_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
description => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'ADMIN',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
host => '*',
lower_port => NULL,
upper_port => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'MISO',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'APEX_210100',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'MISO',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
host => 'smtp.email.us-phoenix-1.oci.oraclecloud.com',
lower_port => 587,
upper_port => 587);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'APEX_210100',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.add_privilege (
acl => 'NETWORK_ACL_D2DB0EE691B34C2DE053B310000A0394',
principal => 'ADMIN',
is_grant => true,
privilege => 'smtp',
start_date => NULL,
end_date => NULL);
COMMIT;
END;
/

When I try to grant execute on
grant execute on apex_210100.WWV_FLOW_WEBSERVICES_API to miso;
ORA-01031: insufficient privileges
grant execute on apex_210100.WWV_FLOW_COLLECTION to miso;
ORA-01031: insufficient privileges

grant dba to miso;
ORA-01924: role 'DBA' not granted or does not exist

grant execute any procedure to miso;
work? why?

I need help , support team ticket goes unanswered.

Partially fixed a non-functioning issue.
Fixed a crash problem when Nametag contains some characters
Speed is now less likely to be trapped by anti-cheat
Fixed various other function

hello Apex Team
it would be great to add the Code Editor option to the Custom Attributes and CSS Class fields for the attributes editor in the Page Designer as other attributes (Pre Text)
thanks

Hi.

I've downloaded tha application "Customers", but when I try install using the file customers.zip, I see the following error:
Gateway Timeout
The proxy server did not receive a timely response from the upstream server.

Reference #1.872c0ec8.1620992195.1727880b

I am using the Oracle Apex free hosting at apex.oracle.com.

What's I doing wrong?

Regards,

Jairo

[Question] - There were a number of other sample apps available. Is the Checklist Manager Sample App available?

mostrar % de palpites por times

Exemplo:
jogo 1: % mandante / % empate / % visitante

Hi,

I am getting this error when I try to import the app:

NOT COMPATIBLE (Your export may contain calls not supported by your Application Express version)

Any possibility to install the app?

Thanks

questions are marked as required in the db, but the poll form does not validate submissions.

We are using an APEX build website as a webview in android 10.
Earlier when we were using an older version(5 something) of apex with older version of android(5.1), all the functionalities were working properly in both desktop browser as well as mobile webview.
After upgrading the android OS version to 10, we could see some UI issues(color differences) along with some major blocker where hamburger menu is not clickable or top level dropdown is not behaving properly. All these are working properly in the desktop.
Any suggestion or solution would be appreciated.

Top 5 de quem está a frente nos palpites.
Em outro momento, tentar definir quem ainda está na disputa

@cczarski-de reporting this issue as per your comment in today's video to reach out if there are any issues.

On apex.oracle.com (App: 186919) I created a new page with an IR using the "Sample-SAP-SalesOrder" Web source and the IR reported this:
ORA-20999: REST Data Source returned an HTTP error: HTTP 400: Bad request

I know the websource is working fine, columns were added and outside of APEX data is returned. Exact same issue in our internal 22.1 instance.

When testing the websource "Test Operation" the same error code is shown (See screenshot).

Thank you Carsten & APEX team

Hi,

I tested the example.

Requested a laptop, let Jane's task expire, then confirmed the task with Steve. The task is then marked as completed, but the workflow seems to get stuck because renewing the task generates a new ID, apparently breaking the connection to the workflow.

How can I update the workflow with the correct task?

link to oracle forum

br
Hannes

error ORA-01403 when export application "Universal Theme 23.1 Reference" with readable YAML/JSON selected

Error exporting flow 207372. ORA-01403

APEX forum link

I just downloaded these 2 zip files (sample-collections.zip and sample-interactive-grids.zip) and they're both corrupted.

When I try to open it using 7-zip I got error : .zip is invalid !

Wednesday Jun 01 2022 02:10 PM Eastern

Currently you can add more than 20 questions but you only view 20. I checked in the code and noticed its hardcoded, it will be great if this can be used as a parameter at the poll settings level.

I am unable to refresh the region as I am passing "Submit item" to limit the query based on different division. Is there a way to refresh the region as I changing the division using a "Select List"?

Given the simple installation instructions, the app does not install into APEX 21.1.3.
Are there more detailed installation instructions? This app is being installed into a different workspace so does the workspace id have to be changed within the installation SQL?

Testing out the Team Calendar

I can add events ok, but how do I delete them? Can't see anywhere to do that

what's the story behind the mandatory format "Please use YYYY-MM-DD "

In APEX 22.1.0, after installing the Sample Maps application from Gallery and running the US States (flat) page, I am attempting to load the full dataset, both states-full.json and airports-full.json which were last touched 2 years ago from this repo (https://github.com/oracle/apex/tree/22.1/sample-apps/sample-maps/), and encounter the following error:

ORA-39861: domain index is marked LOADING FAILED/UNUSABLE...

See fuller technical info:

is_internal_error: false
ora_sqlcode: -29861
ora_sqlerrm: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 56 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491 ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856 ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 330 ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 414 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 2901 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2618 ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2654 ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 35 ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 1279 ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 3093
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 1591063652815334462
component.name: Load Full Dataset
error_backtrace:
ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 56
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 124
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2491
ORA-06512: at "ABBREV_BACK.EBA_SAMPLE_MAP_LOAD_DATA", line 38
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SYS_SQL", line 2120
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 856
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 2452
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 96
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC_PLSQL", line 330
ORA-06512: at "APEX_220100.WWV_FLOW_CODE_EXEC", line 414
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC_LOCAL", line 2901
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2618
ORA-06512: at "APEX_220100.WWV_FLOW_EXEC", line 2654
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 35
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS_NATIVE", line 1279
ORA-06512: at "APEX_220100.WWV_FLOW_PLUGIN", line 3093
ORA-06512: at "APEX_220100.WWV_FLOW_PROCESS", line 170
error_statement:
begin begin
    eba_sample_map_load_data(
        p_load_from          => :P501_SOURCE,
        p_states_file_name   => :P501_STATES_FILE,
        p_airports_file_name => :P501_AIRPORTS_FILE,
        p_proxy_override     => :P501_PROXY_OVERRIDE );
end;
end;

Im trying to save oracle apex report in pdf format in DB table.

When i used the advisor to check my app
The deprecated Date picker jquery items result was duplicate
sometimes the item show more than 10 results for same item

Hello, I'm unable to install any of the sample apps on the OCI ADB APEX installation. I download the 21.1 version from the git branch. However, when installing it, I'm getting the below error

I'm not sure if it is something related to the proxy that is discussed in this thread.

I'm having this issue when trying to install many of the 21.1 version apps. Not sure if I have to config any network ACL within the ADB.

Appreciate if someone can help me in resolving this issue.

Thanks!
Senthil

Originally posted by @sensub in #25 (comment)

This issue is with all master/detail screens created using oracle apex.
run the master detail screen and do the below steps to see the error.

1. click on any row in master grid.
2. during the time detail screen is loading the data, click any other row in the master screen
3. you may have to do this one or more times to produce the error.

We did lot of research on this and now we are asking our customers not to click any other master row when detail row is loading. is that the correct way of doing it ?

Pls find below the error shown in the browser console screen

interactiveGrid.min.js?v=22.1.0:6 Uncaught TypeError: Cannot read properties of null (reading 'serverOffset')
at q... (interactiveGrid.min.js?v=22.1.0:6:16443)
at P (interactiveGrid.min.js?v=22.1.0:1:1128)
at Object.forEachInPage (interactiveGrid.min.js?v=22.1.0:1:17452)
at Object.next (interactiveGrid.min.js?v=22.1.0:1:16854)
at Object._drainWaiters (interactiveGrid.min.js?v=22.1.0:1:33703)
at interactiveGrid.min.js?v=22.1.0:1:8607
at c (desktop_all.min.js?v=22.1.0:2:28327)
at Object.fireWith [as resolveWith] (desktop_all.min.js?v=22.1.0:2:29072)
at Object.s. [as resolve] (desktop_all.min.js?v=22.1.0:2:30973)
at interactiveGrid.min.js?v=22.1.0:1:8474

I stuck when using the plugin with Oracle DB 12.1.0, After debug the plugin code I found you use json_table to represent the data from APIs, So I do an alteration on the plugin to work correctly with my database version and I used apex_json instead of json_table, If you have any way to consider the code based on the DB version I think it will be an advantage, I hope if the pagination new feature in APEX 21.2 not work with the same concept. Thanks for the great plugin and features.

function get_summary( p_response clob ) return t_summary 
is
    l_summary  #t_summary;
begin
    apex_json.parse(p_response);
    select 
    apex_json.get_varchar2(p_path => 'page'),
    apex_json.get_varchar2(p_path => 'total_results'),
    apex_json.get_varchar2(p_path => 'total_pages') 
      into l_summary.page,
           l_summary.total_results,
           l_summary.total_pages
      from dual;
    return l_summary;
end get_summary;

Hi,
the Readme file of the Sample Calendar App (22.2) mentions:
"PL/SQL calendar control examples that show data in a vertical timeline, as well as a CSS Gantt chart also based on PL/SQL code."
However I con not find any GANTT chart in the application.

Any help appreciated.
Jan-Peter

Autorest is wrongly generating url.
Please check.

Just stumbled over a small issue in the customers sample app (version 21.2) on page 59. When I click on the logo view ... the session gets lost, and I need to log in again.

See Twitter thread here: https://twitter.com/daust_de/status/1473927646681653251

To be sure that there is a bug on the apex side I tried it on the simplest solution,
I created the pl/sql action and set it on create event for the task definition. The whole code looks like this:

insert into TMP_LOGS
values('123');

The error I'm getting doesn't say me anything:

Exception in "do_create_task":
Error Stack: ORA-06510: PL/SQL: nieobsługiwany zdefiniowany przez użytkownika wyjątek
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
Backtrace: ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314
ORA-06512: przy "APEX_240100.WWV_FLOW_APPROVAL", linia 2314

When I change the event in the action definition from create to the task completion, then it works without any problems. After task is approved new record shows in tmp_logs table and the process proceeds.

Add condition text to single choice question.
Example:
Do you have Allergies (No/Yes), if yes show a required text feild next to Yes to add the allergies you have.

How to setup a minimum and maximun size automatic zoom for entire app?

On mobile view of an app, the fonts are so small. I need an automatic zoom that affect all pages without user especific action.

Obviously the fonts can't be reduced or be augmented automatically without limits.

I'm working on a plugin (region) and it should dynamically attach elements to view.

To keep the app look and feel I'm using all the Oracle APEX Universal Theme CSS classes. But dynamic added items does not have attached event handlers and the label ends up not floating above input.

Any idea?

I have this error when I click Create Opportunity

I tried to change the Time Zone but still the problem.

Im new in apex. Sorry in advance.
Thank you.

I used to have a checkbox in treeview in Oracle apex 5.0 and it worked very well with jstree classic but is not working any more. May I know any possibility to add checkbox within treeview to make treeview editable in oracle apex 20.1

There was an error when opening after downloading sample-application-search

from the sample application.

Hello,

I've installed the Quiz app in apex.oracle.com instance.
Made my poll, invited by email users. Email are received but once open the link we get the follozing error

Session state protection violation: This may be caused by manual alteration of a URL containing a checksum or by using a link with an incorrect or missing checksum. If you are unsure what caused this error, please contact the application administrator for assistance.
Contact your application administrator.

Any help ?

Quantidade de palpites
Valor do prêmio

Show or hide question based on other question answer from the same section (or others).
Example:
Do you have children: yes/no
If yes show other question (How many chlidren you have)

error has occurred
Error during installation of Sample File Upload and Download app.

I had upgraded my application to 21.1 yesterday

When switching to an RTL language labels stills aligns left
after checking the CSS I have found out the following line
.u-RTL .t-Form-labelContainer {
text-align: left;
}
So I have to add the line
.u-RTL .t-Form-labelContainer {
text-align: right !important;
}
in page inline CSS to fix temporarily

I've encountered an issue where arrow icons at the marker ends of a graph layout are missing when the layout is set dynamically using a dynamic action. This issue seems to occur consistently under the following conditions:

Here is the code used:

const { self } = apex.region('graph'); self.settings = { ...self.settings, layout: 'force' };

Result:

If we look at the browser console, we can see that the marker end is missing

Have a single OCI Workspace with an existing App using application-based authentication. Installed Polling App in same workspace, different schema than existing App. Turned on Workspace Sharing in both App Shared Components App Authentication. Added a button in orig App to redirect to Polling App to test, but errors and says: "You are not authorized to view this application, either because you have not been granted access, or your account has been locked. Please contact the application administrator.
Access denied by Application security check". Also, do not want to break ability to e-mail links to polls.
Suggestions please. (And, thanks for the Polling App, a big help)
Thanks

Well,
for some reason, I receive a NOT COMPATIBLE after importing the Oracle owned POLL SAMPLE (marketing, tracking)
I downloaded the zip from github and imported into a new Oracle APEX workspace via BUILD import... .
I continue to look around. Nevertheless, if you have any ideas, go ahead and response to me :-)

Thank you!

Hi,

thanks for the great example!

I have question, is it not clear to me how display the add the "delete rows" inside the action menu and how to display the edit button in the toolbar of the interactive grid.

Could you maybe explain?