 |
Hi everyone , has anyone integrated .net with apex ?
27-Jul-2024 10:34:AM by: MO SHQIERAT
|
 |
Hi all,I would like to ask if somebody had used S3 as external object storage and integrated it with APEX?
26-Jul-2024 10:02:PM by: Mohannad Amarneh
|
 |
Has anyone been able to get the Movie Watchlist App demo working from the LiveLabs? I got as far as the first four steps.
I realize I probably needed to set up an ACL on the database but I keep getting ORA-24247. This is what I did:
(DEV is the oracle user)
Can anyone see what I might have missed?
```begin
dbms_network_acl_admin.create_acl(acl => 'themoviedb.xml',
description => 'Access to the Movie DB',
principal => 'DEV',
is_grant => TRUE,
privilege => 'connect',
start_date => systimestamp,
end_date => NULL);
dbms_network_acl_admin.add_privilege (
acl => 'themoviedb.xml',
principal => 'DEV',
is_grant => TRUE,
privilege => 'connect',
position => NULL,
start_date => NULL,
end_date => NULL);
dbms_network_acl_admin.assign_acl(acl => 'themoviedb.xml',
host => 'themoviedb.org',
lower_port => 80,
upper_port => 80);
dbms_network_acl_admin.assign_acl(acl => 'themoviedb.xml',
host => 'themoviedb.org',
lower_port => 443,
upper_port => 443);
commit;
end;
/```
26-Jul-2024 02:40:AM by: Fernando Luna
|
|
How secure is APEX+ORDS out of the box? What caveats are there for creating an e-commerce type of application that is available publicly on the Internet (but which requires authentication provided by us to even do anything with it)?
I'm assuming I'd have ORDS sit on another machine on a DMZ separately from the database and that I'd have to make sure to sanitize inputs (via say the apex_escape API). What other considerations might there be?
25-Jul-2024 09:32:PM by: Fernando Luna
|
 |
Hi all
Any idea if we can integrate or connect to KDB database through rest data services from Oracle APEX which is running in OCI.
Thanks
25-Jul-2024 08:14:PM by: pritham9
|
 |
Hi All,
We have horizontal bar chart, Dept vs emp count with enable live scroll & zoom due to too many departments.
when we scroll in bar chart, the emp count axis auto scale based on displayed departments.
for ex. when char loaded axis is 0 .. 10 .. 20 .. 30 .. 40 ..50,
after scroll if less count then it's auto scale to 0 .. 5 .. 10 ..15 ..20 ..25
How can we disable that auto-scaling while scrolling?
25-Jul-2024 06:18:PM by: Shitul Borad
|
 |
Anyone know when APEX PSE's will get applied OCI environments, and can you requested them applied?
25-Jul-2024 10:43:AM by: Nigel Molloy
|
 |
Oh, and if you run the Advisor on it, the Advisor crashes.
25-Jul-2024 02:34:AM by: Trev
|
|
Here's a weird one. Apex 5.0. We have a page in our development environment that gives the following error when we try to open it _in the editor_:
Error: error - Not Found
Nothing is shown in the editor after the error. The page runs if navigated to within the application. The page loads in the editor in our QA and production environments. The application is copied from dev to qa regularly. The page hasn't been updated for 4+ years. I tried copying the page from production back into dev but that made no difference.
Any idea how I can determine what's going on here??
25-Jul-2024 02:28:AM by: Trev
|
|
Not sure where this might be best asked, but, essentially, is there an example somewhere of a way to write a webpage with APEX that presents like a read-only search page until you authenticate? Sort of in the same idea as a wiki can behave (like wikipedia), if you know what I mean.
Is there a sample app like that? How involved would that be?
25-Jul-2024 01:44:AM by: Fernando Luna
|
 |
Hi all,
I am having trouble with APEX emails. We send them to a Barracuda spam filter in front of our internal mailbox. We have been using this solution since late 2020. For reasons unknown, last week on 7/16, mails are delivered but APEX is recording error "ORA-29278: SMTP transient error: 421 Service not available". The result is the mails are sent over and over again, since they are delivered and recorded as fail. I have to manually delete them from APEX_MAIL_QUEUE to stop sending them (unless I wait for 14 duplicates).
From what I can tell, the mail job procedure WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE() internally calls methods in SYS.UTL_SMTP. I have been asked for "detailed logs" and the best I can do is grant execute on that package to my schema user and call it with trace level logging:
```begin
apex_debug.enable(apex_debug.c_log_level_engine_trace);
APEX_180200.WWV_FLOW_MAIL.PUSH_QUEUE_IMMEDIATE;
apex_debug.disable_dbms_output;
end;```
However I am told this logging doesn't say much.
From Oracle docs for 19, it seems ANY network issue could have a 421 result:
```278.7 UTL_SMTP Exceptions
This table lists the exceptions that can be raised by the interface of the UTL_SMTP package.
The network error is transferred to a reply code of 421- service not available.```
Any ideas how I can get more detailed errors than what I have already tried? I am still trying to understand where the issue is so we can figure out who to ask for help (read as blame).
Thank you!
24-Jul-2024 10:01:PM by: Doug S
|
 |
Hi everyone, I hope you're all doing well. I'm looking for recommendations on QA tools for APEX development. What QA tools or frameworks do you use or suggest for testing APEX applications? Any insights would be greatly appreciated!
24-Jul-2024 05:43:PM by: Alberto Barrio
|
|
Is anyone else experiencing issues with plugin custom attributes not being populated at runtime in version 24.01? We're using Dropzone 2, and we've noticed that p_plugin.attribute_01 is not being set at runtime, even though a default is specified. Any help would be appreciated :pray:
24-Jul-2024 04:04:PM by: Nigel Molloy
|
 |
I need urgent help regarding Application Export from online demo Account ORACLE APEX
Basically my application consist of 84 pages. i have also another one which includes 10 pages . the second one export quickly but 1st one which have 84 pages not export it gives error in oracle apex version 24.1.2
in old version 24.1 it export easily
24-Jul-2024 08:09:AM by: Mukarram Jamal
|
 |
Hi All,
question regarding faceted search.
Is it possible to achieve that search facet searches exact value instead of "instr"?
23-Jul-2024 02:02:PM by: Martin Mirenic
|
 |
Hello Comunity.
Is there a simple way to enable rowclick on classic reports, similar to what we got on content row reports.
23-Jul-2024 12:39:PM by: Emmanuel Ulloa
|
 |
Hi folks,
can someone point me in the right direction? I have an app A and an app B. Both share different modal dialogs. This works very well. But both have different themes + styles. How can I tell the modal dialog which theme/style it should use, depending on the calling app?
23-Jul-2024 10:45:AM by: maik.michel
|
 |
Good morning! Recently, I asked for help on how to include a search item for navigation menu options so that users could filter and quickly find the menu option they are looking for, and it seems that no one has encountered this need and I did not get any response.
So, I'll give it another approach. Do you know in which views or tables the data of the navigation menu lists of Apex applications are stored?... maybe I can create my own searcher by directly accessing those views or tables.
Thank you in advance for your cooperation.
Regards
22-Jul-2024 07:08:AM by: Juan Carlos Pérez
|
|
The "Sample Email Authentication" app does send an email, but I guess there is no place for me to configure a different SMTP server to send to, since this is probably configured globally for all users.
18-Jul-2024 08:28:PM by: Doug S
|
|
Hi - does anyone know if the "free APEX workspace" (url starting https://apex.oracle.com/pls/apex/r/<workspaceid> ) is able to send emails? My company has been trying to understand an email issue and trying to test email sending from somewhere else to help understand it is on the APEX side or the email filter. Thank you!
18-Jul-2024 08:24:PM by: Doug S
|
 |
Hi all! I am migrating application created in APEX 5.0 to APEX 20.2. Some pages contain one "Text field with autocomplete" item based on SQL query. This query returns the same dataset on APEX 5.0 and 20.2. In older version, this item works normally, but on APEX 20.2 this item has poor performance - entering some letters freezes entire app and it comes back after few minutes. Was it any important change in APEX since 5.0 which impacts this type of items? Maybe I am missing something?
18-Jul-2024 06:39:PM by: Wojciech Sowa
|
 |
Hi :wave::skin-tone-2:
I am having an issue with apex collection create_or_truncate procedure taking 30+ seconds to truncate the collection containing around 2000 rows. Has anybody had a similar issue and how did you resolve?
18-Jul-2024 03:01:PM by: Kyle Harris
|
 |
Hi I want to hide the column - APEX$ROW_ACTION but when I do it, it show dots... Do you have a solution?
18-Jul-2024 09:27:AM by: Yarden Avraham
|
 |
hello sir, we have created one dynamic page and in that using html css we have created file upload functionality , No page item is used from upload type its dynamic using html css, In backend we have PlSQL process that executes upload functionality request to object URL using static credentials we have to sent the document to PLSQL process AJAX call from java script , For upload document to object storage , we have created static web credentials and we are passing the credentials while requesting, because our object storage URL is not PAR , I'm trying to sent the document but to PLSQL process but it is taking in clob only , we have to use blob while requesting to object storage.
17-Jul-2024 08:08:AM by: ABHIJIT
|
|
Is there a way to get the correct styling for these "system" dialogs in place?
16-Jul-2024 11:30:PM by: Trev
|
|
The app theme is an old version of the Universal Theme (42). It's unsubscribed. I did try re-subscribing and refreshing, but it _destroyed_ the app.
16-Jul-2024 11:29:PM by: Trev
|
|
After upgrading an app from 5.0 to 23.1, I'm seeing unstyled "session expired" dialogs:
16-Jul-2024 11:27:PM by: Trev
|
 |
Help on Debug. When troubleshooting performance and running the debugger, I find entries that take multiple seconds to execute and the message says: "Found item..." What does that mean? Thank you
15-Jul-2024 04:51:PM by: abul_feed
|
 |
_*APEX Service Instance Version*_
I see that patchset 2 for APEX 24.1.0 is out.
My APEX Service instance still has 24.1.0. What is the process, timeline, for patch sets being applied to APEX Service Instances?
15-Jul-2024 04:41:PM by: Jason Stortz
|
 |
Are data loading pages working for anybody in 24.1? I created a new table, a new data loader definition, a new page and am still getting this error:
```Data profile and uploaded file do not contain any target table column.```
15-Jul-2024 03:26:PM by: Travis Caruth
|
|
DECLARE
filename VARCHAR2(500) := apex_application.g_x05;
filetype VARCHAR2(500) := apex_application.g_x06;
l_blob_real BLOB; -- Declare the blob variable
l_request_url VARCHAR2(1000); -- Declare the URL variable
l_response CLOB; -- Response variable for storing HTTP response
BEGIN
INSERT INTO TABLE1 (NAME)
VALUES ('1');
-- Convert the base64 encoded string (assuming g_x02 contains base64 encoded data)
l_blob_real := utl_encode.base64_decode(apex_application.g_x02);
-- Example: Insert into your TABLE1
INSERT INTO TABLE1 (NAME)
VALUES ('3');
-- Construct the request URL (example: object storage URL)
l_request_url := 'https://bmxh5ioecamstorage/o/' || apex_util.url_encode(filename);
-- Make REST request for each file
l_response := apex_web_service.make_rest_request(
p_url => l_request_url,
p_http_method => 'PUT',
p_body_blob => l_blob_real,
p_credential_static_id => 'creds_3'
);
-- Optionally, handle the response if needed
-- DBMS_OUTPUT.put_line('Response: ' || l_response);
END;
15-Jul-2024 11:48:AM by: ABHIJIT
|
|
apex.server.process("upload", {
x02: file,
x05: filename,
x06: filetype
}, {
success: function(pData) {
console.log("File saved successfully");
alert("File uploaded successfully!");
},
error: function(pError) {
console.error("Error saving file", pError);
alert("Error uploading file. Please try again.");
}
});
15-Jul-2024 11:47:AM by: ABHIJIT
|
|
hello all, I'm trying to sent file from JavaScript code to plsql process , using apex.server_process but unable to request for upload
15-Jul-2024 11:47:AM by: ABHIJIT
|
 |
Hi all. Just facing slight issue with bar chart. I am using this plugin *HTML 5 Bar Chart (Plug-in) apex ,* the length of bar chart is not changing in my case. Tried to change the attributes for the plugin too but that doesn't affect the bar. If someone have an idea what could be the issue? Thanks
15-Jul-2024 11:06:AM by: Muhammed Sharjeel Arshad
|
|
Why redirect to page from menu is too slow in oracle apex 24.1
12-Jul-2024 02:42:AM by: Mukarram Jamal
|
 |
helllo guys , anyone have implemented Auth0 in oracle APEX? I need some docs or videos to understand the process. thank you.
10-Jul-2024 07:32:AM by: erij tiss
|
 |
Hello everyone - I have a little question.
I have a checkbox group and I need an insert into a seperate table, and I have to loop over the entry's in the checkbox group that I get for every value a row in the table . But I have no idea.
09-Jul-2024 02:09:PM by: Andi Oberhauser
|
 |
Hi all, Maybe some experience in this group regarding Azure grants Sharepoint/MSgraph.
I have a Azure Tenant + clientId and secret that is working fine getting the JWT token - i got the response back and all ok, validated the Token as well.
But when trying to do some sharepoint magic(creating a Folder) i get the: *Tenant does not have a SPO license* message, trying to find out why - sharepoint license holders/users are in the tenant/app group but still this error..
Know where to click in Azure but after reading many blogs still dont know why it is presenting this SPO license error... Anybody had same challenge?
Token roles: "roles": [
"Files.ReadWrite.AppFolder",
"Files.SelectedOperations.Selected",
"Sites.Read.All",
"Files.ReadWrite.All",
"User.Read.All",
"Files.Read.All",
"Application.Read.All"
],
09-Jul-2024 02:05:PM by: Thomas Tromp
|
 |
APEX 23.2.
I created a columns chart with dates on the x axis.
I have set he x axis Value->Format to "Date-Short".
Still it shows as full date datetime format like this 2024-06-20T00:00:00 .
This is the source SQL:
SELECT TRUNC(DAYDATE) ,COUNT(USER_NAME)
FROM RELEAVNTACTIVITYROWS
GROUP BY TRUNC(DAYDATE)
ORDER BY 1 ASC
The element shows like this upon inspection:
<text dominant-baseline="text-before-edge" x="70.89508928571429" text-anchor="middle" fill="rgba(0, 0, 0, 0.65)" font-size="12px" id="_dvtActiveElement944732163" aria-hidden="true">2024-06-20T00:00:00</text>
Any idea why would it show as 2024-06-20T00:00:00 when my SQL returns dates?
08-Jul-2024 12:29:PM by: Karim Masarweh
|
 |
Anyone have a simple solution to the following: I need to take a column from a table (199 rows) and pivot it into one returned row of data.. its actually a comment in a view that I need to use in a column header for an export to xlsx. All examples of pivot I have found use an analytic function, whereas I just need to "pivot" each row into a column of data, and yes there are duplicate values just to add to the fun..
05-Jul-2024 01:53:PM by: Tony Miller
|
 |
Hey...can we implement gen ai feature at oracle apex page where we add some prompt in input and get result in output
04-Jul-2024 10:33:AM by: mayurmehar003
|
|
Good morning!
In some of the applications I have developed, the options menu has grown a lot and users ask me if it would be possible to have a search field to quickly find the desired option.
Is it possible to implement a search field to filter menu options?
Thank you very much for your comments and greetings
04-Jul-2024 07:40:AM by: Juan Carlos Pérez
|
|
I'm going thru the process of upgrading a bunch of APEX 5.0/5.1 Applications to 23.2.6 (yessss!) I have an item template called "Required- Above, Large, Stretch" which is a copy of the default "Required - Above" template with Large and Stretch set as the default. After the upgrade, I manually copied and pasted the new Definition html across (Before Label, After Label, etc), but doesn't have "Required Indicator" setting. Do i need to re-create this template as copy? Will i then need to go thru all the items and change them to use this new template? What's the best way to handle "upgrading" these templates?
03-Jul-2024 11:59:PM by: Trev
|
|
Hi all - In APEX WORKFLOW - there is a type: "Human Task - Create" where you can define the Deadline date.
Thing is that when the DEADLINE is past it keeps triggering TIMEOUTS actions that ends up in multiple subFlows in my workflow.
Maybe I dont understand, but why is this - When a deadline is met I would expect 1 TIMEOUT trigger. Do I miss something here?
03-Jul-2024 04:44:PM by: Thomas Tromp
|
|
anybody having issues with the data workshop in 24.1? trying to load from a csv into an existing table and it never progresses. i checked the debug log and it said theres a cursor leak
03-Jul-2024 03:00:PM by: Travis Caruth
|
 |
Error ORA-20022: Email template not found in application
Anyone know how to fix this error?
The workspace was set and the application ID fix to one I know is correct. The name of the TEMPLATE is correct too.
Any idea?
03-Jul-2024 01:46:PM by: Jorge Cribb
|
 |
Hi All, how to integrate stripe payment gateway using Oracle APEX.
03-Jul-2024 07:30:AM by: Amit
|
|
Hi Everyone, how to integrate a payment gateway using Oracle APEX that includes ACH payment includes USD amounts using Oracle APEX. Please help on this one.
02-Jul-2024 12:51:PM by: Amit
|
|
Hi all,
I want to use a popup menu on a card. Can you point me to an idea on how to start?
ThanX :wink:
02-Jul-2024 08:45:AM by: maik.michel
|
 |
Hi, I want to show hidden columns (header_id) in my interactive grid when I download it to excel. please guide
01-Jul-2024 10:17:AM by: Hamza Chishti
|