 |
Hi everyone, I am having a weird issue. I am making a webservice call using `apex_web_service.make_rest_request`
In the application it works fine, I am able to display this query as classic report region:
`select * from table(get_opportunity_by_id('OPP-0000022990'))`
But same query from within the database is giving me `end-of-input reached` error:
What could be the reason? The code that makes the webservice call is attached below. That code is used to get the Json file and then called by another procedure to convert into a table...
16-May-2024 08:26:PM by: eureka7
|
 |
Does anyone know how to clean up records in the `flows_files.wwv_flow_file_objects$` table? Is there a way to do it from the UI or does it need to be DELETE statements? I have files in that table from over 2 years ago that I would like to clean up
16-May-2024 02:53:PM by: EJ Egyed
|
 |
Hi APEX expert, We are facing uncontrolled issue in APEX. In APEX page we are rendering some values/collection data through dynamic action and can see it is set at session level. Next action is we are calling change event react component call through window function. Now issue is REACT call is resetting my all values to initial stage. Now I can see all values which we set through dynamic action or any default values are resetting to null. Could any one help on this?
16-May-2024 12:48:PM by: Rishu
|
 |
Hi all. I wanted to ask if I want to go to previous page using a Back button then *history.back()* works perfect. But if i want to goto previous state of the same page then what could be used for that? Like in the same Interactive Grid? Thanks.
16-May-2024 11:16:AM by: Muhammed Sharjeel Arshad
|
|
Hi all. I had a question regarding the Interactive Report. I want display *'fa fa-check-circle'* or *'fa fa-times-circle'* icons here based on the coloumn values, if value is *Y* then first one and if value is *N* then second one. Is that the right way or need to do it other way round? Thanks :slightly_smiling_face:
16-May-2024 07:30:AM by: Muhammed Sharjeel Arshad
|
 |
Hi All,
We have HTML files in the AWS S3 Bucket. I have an access key and a secret key.
I am trying to fetch the HTML File into Oracle APEX from AWS S3 Bucket with apex web service call, In Authorization need to pass the AWS Signature Key.
Please find attached the SQL file "AWS_S3_API_CALL.sql" for the code that I am using to get the file.
But getting below error while GET API Call. Please refer attached screenshot for error details.
```<Error><Code>SignatureDoesNotMatch</Code><Message>The request signature we calculated does not match the signature you provided. Check your key and signing method.</Message>```
Let me anyone has any idea about the issue.
Thanks.
Shitul
15-May-2024 04:33:PM by: Shitul Borad
|
 |
Sounds like @maxime_tremblay needs to do a blog post! :slightly_smiling_face:
15-May-2024 03:27:PM by: Doug Gault
|
 |
Hi guys, @maxime_tremblay upgraded apex.world to 23ai Always Free on premise. Let us know if you find anything awkward.
Our new version 2.0 with the APEX AI Assistant will probably take till September, so stay tuned, POC is already looking promising :slightly_smiling_face:
PS: If you use an Always Free aka XE you run into space problems even if you are actually just using 4Gig of the available 12Gig. Because Oracle is just looking at the data files with all it's fragmentation. Once you hit the limit, there is no way to do anything with your DB anymore. But you can convert to so called "Big Files" where you can easily defragment your files on the fly and actually use 12 Gig of the 12 Gigs. Maxime knows how to do this move to Big Files which - for us - trippled the value of the Always Free DB.
15-May-2024 02:54:PM by: juergen.schuster
|
|
Hi All. Here in the Apex charts i dont want to display these Values inside these bars. is there a way to hide them from chart? Here in the properties, in Coloumn mapping VALUE i have to select atleast single value.
15-May-2024 01:15:PM by: Muhammed Sharjeel Arshad
|
 |
In apex 23.1, in an IR, I wanted to have a column, which has a radio-group styled as a pill box...
ie like a three way switch... (where user can chooise only one of three values for each row in the Report)
The apex_item.radio_group doco is pretty spare with no real examples - does anyone have any?
And potentially its not what I want, as various posts have suggested:
"Normally a radio button column is used to select just *one* row."
Is this true?
15-May-2024 03:53:AM by: Alister Miller
|
 |
Hi guys,
I developed my first plugin. Does anyone know, how to export a plugin with SQLcl or with an api-call?
Thanx,
Maik
14-May-2024 07:47:PM by: maik.michel
|
 |
Folks, I hope this app will be useful for some of the Oracle APEX projects we work at. For any contributions or suggestions please send it through GitHub.
Cheers,
Sandro
https://www.linkedin.com/posts/sandrogferr_orclapex-oracle-projectmanagement-activity-7196148233000173569-WAc_?utm_source=share&utm_medium=member_desktop
14-May-2024 02:30:PM by: sandrogferr
|
 |
Good Morning everyone, we have an old Microsoft Access "Application". What is the best practise way to migrate this into an APEX Application?
14-May-2024 08:33:AM by: Andi Oberhauser
|
 |
good morning everyone , so while i am implementing a calendar with drag and drop functionnality , so i wrote this code to make some event blocked , but i need to restrict this only for appointments which their id!= P36_APPOINTMENT_ID , Any idea how to do it ?: function(options) {
options.eventShortHeight = 30;
options.slotDuration = "00:30:00";
options.eventMinHeight = 15;
options.eventBorderColor = "#FBC0C0";
options.slotMaxTime = "18:00:00";
options.eventTextColor = "#FBFBFB";
options.eventColor = "#FAB5B5";
options.eventDisplay = "block";
options.slotMinTime = "09:00:00";
return options;
}
13-May-2024 08:45:AM by: erij tiss
|
 |
Hi!
Do you know if it is possible to dynamically set the color of a marker in the line chart component based on a column value? So that I have one line with value markers of different color. I tried with the initialization code, but was so far unsuccessful.
*Ok, got it solved, thanks, Tilen.* The only remaining issue is the now somewhat arbitrary color of the line. Is it possible to decouple the color of the line from the color of the markers?
13-May-2024 05:43:AM by: Alittis
|
 |
Hi,
In IG checkbox column when saving getting below error. I gave default N .
Not sure how to overcome this, In SQL gave NVL(column,'N') and also assigned default value 'N'
Must match the values Y and N.
Appreciate any help.
Thanks
11-May-2024 04:19:AM by: Ravi Kiran
|
|
hello every one , so i am working with calendar component , i am implementing the drag & drop functionnality : update APPOINTMENTS
set startdate = to_date(:APEX$NEW_START_DATE, 'YYYYMMDDHH24MISS'),
enddate = to_date(:APEX$NEW_END_DATE, 'YYYYMMDDHH24MISS')
where APPOINTMENT_ID= :APEX$PK_VALUE;
end; the thing is i just want to drag and drop the appointments which their appointment_id = :P36_APPOINTMENT_ID, i didnt know exactly how to fix that pl/sql code the restrect the action , any solutions guys?
10-May-2024 12:29:PM by: erij tiss
|
 |
Working in APEX 22.2, anyone know if there is a method on a card region to center title.. I tried using a method on the page css:
#<region-static-id> .t-Region-header-Items--title {
text-align: center;
}
With no luck.. any thoughts?
09-May-2024 05:31:PM by: Tony Miller
|
 |
Hello everyone , I want to implement auth0 in my apex application , how to link my database with the auth0
09-May-2024 04:09:PM by: Achraf Gharbi
|
 |
@Jayson Hanes - Oracle APEX PM @Vincent Morneau (APEX Team) gents, any chance we can resurrect this request given the ask wasn't exactly clear enough and was closed thinking it was already implemented?
https://apexapps.oracle.com/pls/apex/r/apex_pm/ideas/details?idea=FR-3337
09-May-2024 03:46:PM by: Matt McGee
|
 |
Hey I have a bit of a challenge here. I'm trying to make a button that will run all the validations on the page and then, only if there are no validation issues run a set_value and also remove that button from the screen. But also, do not close the page I'm on.
I've tried a few things in the settings of the button like making it a SUBMIT PAGE button as well as a Defined by DA button and I've gotten close to making it work. but what seems to happen is that either the button works or the set_value works, but not both.
Is there a different kind of DA that will run all the validations only?
09-May-2024 02:57:PM by: J. Peter MacKay
|
|
Hello everyone , can I trigger a dynamic action after a change in DB ?
I made a trigger that updates a value in a flag table in DB (after an insert in table Chats ) , how can i link the update of the value in table flag with my dynamic action (refresh region)
09-May-2024 12:55:PM by: Achraf Gharbi
|
|
Hello , I made a chat between users , the msgs are been inserted in DB and i don't think it's optimal , is there a way to integrate sockets in oracle apex ? a demo or a tutorial ?
08-May-2024 10:42:PM by: Achraf Gharbi
|
 |
Is this a bug in APEX?
https://forums.oracle.com/ords/r/apexds/community/q?question=strange-item-formatting-1097&session=207609338833561&x01=login300000
08-May-2024 06:58:PM by: turntablez
|
 |
Hello everyone, a little confusion here, if someone can help. I am trying to select one column from this view DBA_SCHEDULER_JOBS
`SELECT COMMENTS FROM DBA_SCHEDULER_JOBS WHERE OWNER = :APP_USER`
I get this error during the SQL query definition.
• ORA-20999: Wrong number of columns selected in the SQL query. See Help of attribute for details.
08-May-2024 01:49:PM by: Hammad Iftikhar
|
|
Hello , i have some troubles while uploading an image and inserting it into my DB , the error that always pops up is : ORA-01465: invalid hex number Contact your application administrator. Details about this incident are available via debug id "1629339363". any solutions??
08-May-2024 10:53:AM by: erij tiss
|
|
Hi, i wanted to ask that is it possible to show this image in the link coloumn for interactive report? I tried like this but that does not work.
`<span class="fa-clipboard-list"></span>`
08-May-2024 09:50:AM by: Muhammed Sharjeel Arshad
|
|
Can some one help on this?
08-May-2024 09:20:AM by: Rishu
|
|
Hello All , I am facing challenge with APEX sso. My application is working fine but once session expired it is returning ORDS 400 bad request error. How to handle this 400 error? It would be great if some one can help me on this.
07-May-2024 05:59:AM by: Rishu
|
 |
Hello all. Been a while since I have had a chance to do any APEX. Last month I started working on a general purpose pl/sql library for various AI providers with tooling/utility, mainly as a challenge learning exercise. Anyway now I find myself needing to build a ChatGPT type of UI for it to do some testing. Curious if anyone has already essentially cloned that style of interface in APEX. I don't need any AI fucntionality, I will add that. I just need the UI look and feel. If you know of anything let me know. In the meantime I will likely start plugging away at building one.
06-May-2024 04:41:PM by: Ethan Ray Post
|
 |
why I am getting this error when I run my application?
06-May-2024 03:24:PM by: mayurmehar003
|
|
Hi All, had a question regariding Interactive Grid Coloumn. Is it possible to Direct a Link colomn to two different pages based on a condition using Dynamic Action? If yes than how can i achieve that?
06-May-2024 02:21:PM by: Muhammed Sharjeel Arshad
|
 |
Hi everyone
I want to modernize my application, for that need ideas for my navigation menu and home page, app was developed using version 18 and now imported to 23.1
Thanks in advance
05-May-2024 02:43:PM by: Zahid Waheed
|
 |
Is it possible to use React in Apex? We want to introduce advanced technologies within Apex.
05-May-2024 06:54:AM by: Yarden Avraham
|
|
Hi,
On Autonomous(19c version) ATP-APEX we are trying to setup customer managed ORDS as per document.
In the below step while installing which user we give in-place of EXAMPLEUSER?
• We already have running ATP-APEX
• Now want to configure customer managed ORDS on it
We created new user ORDSTEST(in-place of exampleuser) and tried but got error "insufficient privileges".
Do we need to grant any roles to ORDSTEST that picked?
SQL> @/path/to/installer/ords_installer_privileges.sql exampleuser
Please need some help.
04-May-2024 12:15:AM by: Ravi Kiran
|
 |
Drives me insane that LOV SQL turns into PL/SQL automatically when you add a comment in the wrong spot. it's a minor pain to fix in the grand scheme, but just one more annoying quirk to have to remember.
03-May-2024 04:25:PM by: Travis Caruth
|
|
Hi all,
We are Integrating Okta with Oracle Apex as Social Sign in.
We already did in Apex free workspace and it's working perfectly there.
But when we trying with the Private Apex (Installed on server), I am getting below error while running the apex app to login(Please refer attached screenshots).
We checked in Debug shows below (Please refer attached screenshots):
- ora_sqlerrm: ORA-29273: HTTP request failed
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 757
ORA-28759: failure to open file
Note: We already added wallet configuration at database for okta root certificate. and added wallet details to Internal Workspace.
Oracle DB: 19c
Apex: 20.2
For Test,
If we calling that URL from SQL then getting error
select apex_web_service.make_rest_request(
p_url => 'https://trial-8247530-admin.okta.com',
p_http_method => 'GET' ) from dual;
Result: ORA-29273: HTTP request failed
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 1157
ORA-06512: at "APEX_200200.WWV_FLOW_WEB_SERVICES", line 757
ORA-28759: failure to open file
------------------------------
If we calling that URL from SQL with wallet info then getting response.
select apex_web_service.make_rest_request(
p_url => 'https://trial-8247530-admin.okta.com',
p_http_method => 'GET' ,
p_wallet_path => 'my_wallet_path',
p_wallet_pwd => 'wallet+pwd') from dual;
Do anyone have any idea on this error?
Thanks,
Shitul
03-May-2024 04:47:AM by: Shitul Borad
|
|
Anyone ever tried doing color coding lov elements before? any suggestions? I have a customer who saw an article and thinks they want this, but don't realize it uses hardcoded values for determining color attributes..
01-May-2024 08:16:PM by: Tony Miller
|
|
Having some issues with a faceted search that's looking at about 110k rows. we'll use automobile sales as an easier to understand taxonomy
> -make (table containing ford, dodge, kia, etc)
> |-model (table containing all models, with a fk to make)
> |-year
> |-seller
in the results area of the faceted search, i'm showing used cars for sale. these are saved in a table called listings. each listing has a year, seller name, fk to model.
if i pick a make with just a few cars for sale, my model facet won't show all of the returned values. additionally, for big makes like ford or dodge, we're hitting the 4000 distinct item limit for the model facet.
looking for others who have run into limitations of the faceted search, and possible workarounds.
01-May-2024 03:55:PM by: Travis Caruth
|
|
Hi,
How to hide "Help" from Actions menu of IG? Was able to hide other unnecessary but struggling with Help.
Thanks for your help.
30-Apr-2024 05:56:PM by: Ravi Kiran
|
 |
Hello everyone, I'm experiencing the following issue when trying to view components for export. In the APEX forum https://forums.oracle.com/ords/apexds/post/apex-23-2-1-bug-cannot-export-components-due-to-ora-06502-6577, a comment suggests that the value can be suppressed by modifying the view WWV_FLOW_APPL_EXPORT_COMPS. My question is whether this modification could cause other problems when exporting the entire application.
30-Apr-2024 02:12:PM by: Alberto Barrio
|
|
Hi Team,
As an individual APEX-APP developer got rescued from many road blocks here. Thank you all.
Quick question on licenses. Our APEX-APP(it's one PAGE SURVEY APEX APP) will have 1,50,000 concurrent users logged in and answering SURVEY poll on a SPECIFIC day. Once the SURVEY(8-15hrs time) is over users drop from 1,50,000 to 200-500.
We are planning to increase ECPU's on SURVEY published date. Down ECPU's to 2 once SURVEY is complete End of the day.
For this kind of need, Is UPGRADE license from "APEX Application Development to Autonomous Transaction Processing" better option?
Does ATP provides auto failover compared to "APEX workload type" licenses?
Appreciate any guidance.
29-Apr-2024 03:57:PM by: Ravi Kiran
|
|
Hey everyone , I am working on implementing auth0 in my oracle apex application, I successfully done that and I can login with gmail/fb...
the problem is with the authorization , I didnt know how to link auth0 with my database (for exemple ,I used a query to build mu auth if he finds a row then true, I have table person with person_id as attribut , I want every new user to have a new person_id if he doesn't have already),I am sorry if it's a bit confusing , I appreciate every document or video which can help me , thank you
29-Apr-2024 10:17:AM by: Achraf Gharbi
|
|
Hi All. I wanted to ask that *what is the easiest way to check if in the apex application code there are schema aliases used?* If someone can help out here? Thanks :slightly_smiling_face:
29-Apr-2024 09:56:AM by: Muhammed Sharjeel Arshad
|
 |
Hi All
Trying to format the title of the modal dialog using CSS and unable to do so.
I'm trying to target every class I see in the inspect screen, but nothing seems to
From the Oracle Forums, I understand modal dialogs are special because they involve an iframe and other stuff.
Does that mean I cannot use CSS for the title?
If no, can I remove the title bar using css so I can add a "normal" region instead?
I tried something like this that was suggested in the forums for removing the x button, but still nothing happens...
_.dialog_class .ui-dialog-titlebar-close{_
_display:none !important;_
_}_
Thank you
28-Apr-2024 07:12:PM by: Karim Masarweh
|
|
In Interactive grid we have AUTO COMMIT on a column immediately after change though PL/SQL DY.
• Write simple PL/SQL to update table row using rowid
• But IG still sees the column cell is DIRTY(as we updated but not invoked ANY SAVE of APEX)
SAVE is working but when we try to go another "Saves Report" getting this message.
At form level turned off "Warn on Unsaved changes" but still getting it.
Any idea how we can avoid this message on SAVE of column.
Thanks for all the help.
28-Apr-2024 02:07:PM by: Ravi Kiran
|
 |
Hi All
I have REST API request that returns a base64 file as a CLOB. When converting base64 to BLOB using *apex_web_service.clobbase642blob* returns the file with no problem if it is PDF, but in case of images, png or jpeg, it generated the file but not readable with the error *"This is not a valid bitmap file".* I have used many other functions other than *apex_web_service.clobbase642blob,* but with the same error.
Could any one have a solution to convert base64 to file (blob) especially for images?
Attached file is a sample base64 image file:
27-Apr-2024 01:43:PM by: Kareem
|
|
A classic question, how do I unlock and change the internal workspace admin account's password? I can login to SQL Developer Web as the admin account, but it's my understanding that's a different 'admin'. Using APEX account authentication IIRC.
I've tried something like this:
```BEGIN
APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10);
APEX_UTIL.UNLOCK_ACCOUNT(P_USER_NAME => 'ADMIN');
END;```
but I get a message
> ORA-20987: APEX - Security Group ID (your workspace identity) is invalid.
I've also tried reading the `wwv_flow_fnd_user` table, but this admin user doesn't have access. Lots of searching leads me to APEX 4 and 5, so I'm not sure if maybe that table used to be the right way.
26-Apr-2024 04:32:PM by: Travis Caruth
|
 |
Hi everyone,
do you have any idea on how do you prevent your developper to create a page within a specific range of pages ? Or in opposite way, how to allow a specific range of pages. hope that makes sense :)
26-Apr-2024 10:03:AM by: Pierre-Louis Giros
|
|
Hey...Is it possible to use the groups in authorization that created in OCI (ex.Admin , Manager)
26-Apr-2024 08:58:AM by: mayurmehar003
|