i want to connect my apex application with multiple databases, please guide me how to get there?
21-Mar-2019 07:48:AM by: Zahid Waheed
Or you could also have a look at the dropzone plugin
20-Mar-2019 10:33:PM by: maxime_tremblay
thought that might be the case. thanks Maxime.
20-Mar-2019 10:33:PM by: trevorh
@trevorh instead of an inline dialog you could use a standard page dialog Then on dialog close you could refresh anything that needs to be on the parent page
20-Mar-2019 10:32:PM by: maxime_tremblay
@roelhartman Thank you, Roel. I just saw your response. I'm looking for information on that today, but I'm still trying to recover from other errors I created earlier, so, I may not have that totally digested for a little bit. I think that what I'm hearing from you and Maxime is, I have been approaching incorrectly (due to not understanding how the intrapage stuff is done). I appreciate the help.
20-Mar-2019 10:31:PM by: Marc Visconte
Any known work around for this?
20-Mar-2019 10:30:PM by: trevorh
There is no error if I do not select a file to upload.
20-Mar-2019 10:30:PM by: trevorh
apex 5.1. Trying to use a 'File Browse" item in a "Inline Dialog". Save button triggers a DA that has a Pl/SQL block which gets and saves values, but I'm getting a 404 error. "server/wwv_flow.ajax not found". I assume that means there is a server side error (which I have no access to)?
20-Mar-2019 10:30:PM by: trevorh
I would simply have two parameters for your two use cases P2_ID : would be used to edit a current record P2_COPY_FROM_ID would be used to copy from another record Then in your form page load processes you can fetch the values from either the record or the record to copy There’s no need to pass all values. You only need the ID :wink: Then if you ever change the table you only need to change it at the form page level And not for every place you have your link
20-Mar-2019 03:41:PM by: maxime_tremblay
Yes, there is. Just pass the ID (and maybe a request “COPY”) and define a Process in that Edit page to fetch the record data based on the passed in ID.
20-Mar-2019 03:38:PM by: roelhartman
> *itemNames* >Comma-delimited list of item names used to set session state with a URL. > >*itemValues* >List of item values used to set session state within a URL. To pass a comma in an item value, enclose the characters with backslashes. For example: > >\123,45\ >Every character sequence except backslash comma (\,) can be enclosed with backslash.
20-Mar-2019 12:30:PM by: maxime_tremblay
@Marc Visconte have a look at this
20-Mar-2019 12:29:PM by: maxime_tremblay
I ran into an issue I didn't see coming: Some of the data in one VARCHAR field has embedded special characters. Possibly TAB, but probably CR and LF. When I passed this field to an APEX FORM page, the result was that the containing ITEM field showed only partial data, subsequent ITEMs contained remaining data, and all of the rest of the ITEM fields had their data pushed down a similar amount. ?? What is the simplest to PREVENT this? The data comes from records, shows up in an iReport, and gets passed to the form page through the page link: Name: P41_DESCRIPTION, Value: #DESCRIOPTION#, etc. Can I used functions in the link field? (I suspect not) [ Note: After looking at the report content, the characters that are breaking this are ... COMMAs. How the heck can COMMAs be causing this much grief? Is this going to happen with OTHER "special characters"? Some of the descriptions have double-quotes (") and single-quotes/appostrophes (') ! And what will happen if there are embedded #, &, or : ? Oy! ]
20-Mar-2019 03:44:AM by: Marc Visconte
Any one has idea
19-Mar-2019 09:52:PM by: Guangyu Mao
19-Mar-2019 07:34:PM by: dgielis
Hi All, Issue Type: Oracle APEX AOP I have created and IR report using `case` statement and I want to download as excel by using AOP plugin. In my SQL query two `case` statements are there but pulgin is returning only one column values. I need to download all the column which are contain in IR. I have created sample demo in| Kindly any one help me in this. workspace:arjun_ind username:arjun_ind password:arjun_ind Application:44885 Page:23 Excel output; Apex R & :anguished: Custom Excel Template {#aopireportdata} {ENAME} {DEPTNO} {MY_SAL} {/aopireportdata} {aaaa_region_name} In this `less sal` column data is not showing if I add manually template not working properly.(column don't have any conditions)
19-Mar-2019 06:38:PM by: arjun
Try to set up a language selection page like that on my app. Anyone have idea how to create page like that. Any source that I can follow with. Thank you for any help.
19-Mar-2019 06:31:PM by: Guangyu Mao
I thought as much, but thanks for confirming! :slightly_smiling_face:
19-Mar-2019 08:42:AM by: Ross Henderson
original est is column 1 and revised est amt is column 2 when tabular form coming from clicking of create button then original est is editable and revised est amt is uneditable and when it's coming from cliking on revised button then original est amt is uneditable and revised est amt is editable . this will solve using this qurey is it the correct method @maxime_tremblay begin for i in 1..apex_application.g_f01.count loop update test set REVISED_EST_AMT = apex_application.g_f05(i) where PROJECT_id = apex_application.g_f03(i) and flex_id=apex_application.g_f04(i); --and nvl(revised_est_amt,0)=0; end loop; end;
19-Mar-2019 05:20:AM by: Amit
Did anyone know how to fix it?
19-Mar-2019 02:45:AM by: Guangyu Mao
Hello all. is there a way to export an Interactive Report with a subtotal row that was created using Actions > Format > Aggregate?
18-Mar-2019 09:18:PM by: abul_feed
I am having this trouble. So when a new user requests for a new workspace and thet get an email saying Workspace Request Approved, I click on Create workspace. It takes me to this page.But when I click on Continue to Sign in screen, it does not redirect to anything. Background - I am trying to run wwv_flow_api.set_security_group_id (p_security_group_id => apex_util.find_security_group_id (p_workspace => 'ROSYPARMAR1') ); APEX_180200.wwv_flow_fnd_developer_api.f4050_55_provision_workspace(p_provision_id =>,p_approval_message => 'Approved',p_acceptance_message => 'Approved'); wwv_flow_api.set_security_group_id (p_security_group_id => 10 ); -- security group id of admin user APEX_180200.wwv_flow_fnd_developer_api.f4700_73_provision_workspace ( p_provision_id =>, p_sign_in_url => l_url, p_msg => l_msg);
18-Mar-2019 07:04:PM by: rosyparmar
server side will not generate the region at all in the html whereas using a dynamic action will simply hide it and its html will still be available to the user when using the server-side condition you will not have to process what is in that region, so page would load a little bit faster if you need to show or hide the region dynamically according to let’s say an item’s value, then the dynamic action is probably what you need otherwise you should probably use a server-side condition
18-Mar-2019 05:08:PM by: maxime_tremblay
which one is column 1 and which one is column 2? are they both editable?
18-Mar-2019 05:05:PM by: maxime_tremblay
@Amit I haven't tried this w/ a tab form, but for a regular form, I would: Create a dynamic action for PG#_Field_1, ON CHANGE of pg#_field_1, with a TRUE action of SET VALUE, of whatever "Set Type" you prefer. "Items to Submit" would be pg#_field_1. Affected Elements would be Item(s), pg#_field_2 The Set Type I use is SQL Query, and I usually want to CASE WHEN :pg#_field_2 IS NULL as part of my query.
18-Mar-2019 04:49:PM by: Marc Visconte
When showing/hiding regions, what is the best practice: Using the Server-Side Conditioning or is using Dynamic Actions okay as well?
18-Mar-2019 04:31:PM by: Ross Henderson
10 is also come automatically in revised est amt column.
18-Mar-2019 09:38:AM by: Amit
Hi All, i am using tabular form in oracle apex 5.0 and i have a requirement like what ever values in Column 1 that exactly copy to column 2 and when column 1 values is changed by user then column 2 values also changed while submit the tabular form. how can i achive this one. i am also using some java script but it's not full fill the requirement. @maxime_tremblay
18-Mar-2019 09:38:AM by: Amit
@svenweller Thanks i was try but didn't fetch mac. after i used this procedure owa.cgi_var_name('Parameter Name') ;
15-Mar-2019 12:38:PM by: aditya_shah3592
Got the easiest solution :grinning: .Download all the static files as zip. Remove the folder which are not required in the downloaded file.Delete all the static files by clicking on "Delete All Files".Then upload the zip file again.
15-Mar-2019 07:36:AM by: Pk
Hi Guys,I have uploaded a zip file in the "Static Application Files" by creating directory "TEMP".The zip file have many folder and sub folder.I want to delete all the files in the TEMP directory instead of deleting individual file .Is there a way to delete it.Any plsql code which will delete the files ?
15-Mar-2019 05:00:AM by: Pk
14-Mar-2019 01:08:PM by: fahad qadir
Hi, How can i change the font of my Oracle Apex Application?
14-Mar-2019 12:31:PM by: demahA
Hi Guys, I am trying to post file using slack web api (files.upload method) to slack channel through rest services. I am facing this response - "invalid_form_data" on running this. Any help/suggestion on this would be appreciated. I would like to know how to pass the parameters to this api. Reference link : I am following the article Thanks.
14-Mar-2019 08:24:AM by: ashwinrao
Here’s what I would check No need to move the plsql action in an Ajax callback yet, unless you want to have only one JavaScript action or that you want to have it in a pure javascript way (no dynamic action) Make sure that the items you set in the JavaScript action are also define in the plsql action “items to submit” attribute This will make sure as Swen suggested that you have the new values in session state for the plsql action If it still does work I would add some logging in the two actions to be able to trace everything `console.log` for the JavaScript action and `apex_error.message` for the plsql
13-Mar-2019 01:32:PM by: maxime_tremblay
I've been using ORDSYS.ORDImage to resize some images in an old apex application. The application is being moved onto a new database where Oracle Multimedia is not installed. Any ideas on alternatives?
12-Mar-2019 10:23:PM by: trevorh
1. Remove the WHEN OTHERS part. If an error happens you want to see everything, not just the part that you grabed with SQLERRM. 2. The problem most likely is that the javascript actions sets the page items, but those values are not in the database session state. Just think that both actions run at the same time. The solution to that is to use a single javascript action. First create an on demand process (can be on page level) with your update and then call it via apex.server.process inside the same javascript action that sets the values. You can set the values either by saveing the pageitems or by sending them via X01, X02.
12-Mar-2019 05:46:PM by: svenweller

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Ahmed Haroon
21-Mar-2019 07:39
Apex 5.1: how to add Search in "Form on a Table" single record Form
0 replies
Jose Aróstegu
20-Mar-2019 23:16
Interactive Grid dependant Select List items
0 replies
20-Mar-2019 22:29
Tabular form validation onchange column value
0 replies
Robert Sibek
20-Mar-2019 20:26
Generate JavaScript array of objects from Interactive report column values
1 replies - last reply: 20-Mar-2019 21:00- by: LA County APEX
20-Mar-2019 19:42
Fetching data (low level)
5 replies - last reply: 20-Mar-2019 22:10- by: fac586
20-Mar-2019 18:01
how to enable save report public option in action menu save report option under named report
1 replies - last reply: 20-Mar-2019 18:01- by: ReemaPuri
20-Mar-2019 16:33
APEX certification matrix
0 replies
Alexandra Rob
20-Mar-2019 15:40
Automated Row Fetch, ORA-01722 No Data Found
1 replies - last reply: 20-Mar-2019 16:21- by: Neil Clare
20-Mar-2019 14:28
BUG: ORA-06553 error in Object Browser
1 replies - last reply: 20-Mar-2019 17:14- by: Carsten Czarski-Oracle
20-Mar-2019 14:21
Display label layout on the same line with Universal Theme
1 replies - last reply: 20-Mar-2019 14:47- by: fac586
A. Olsen
20-Mar-2019 11:07
apex.server.process fails: "apex is not defined"
4 replies - last reply: 20-Mar-2019 14:46- by: A. Olsen
Barry Brierle
20-Mar-2019 10:53
APEX_UTIL.RESET_PW returns ORA-20001: Package variable g_security_group_id must be set
0 replies
Fahd Bahoo
20-Mar-2019 10:19
Multilingual Application in Apex
1 replies - last reply: 20-Mar-2019 10:22- by: fac586
Arthur R.
20-Mar-2019 09:53
[APEX5.1] ORA-20987 Unexpected internal application error
2 replies - last reply: 20-Mar-2019 14:13- by: Arthur R.
20-Mar-2019 08:22
added view to apex_dictionary and search doesn't work
3 replies - last reply: 20-Mar-2019 12:57- by: Scott Wesley
20-Mar-2019 07:58
3 replies - last reply: 20-Mar-2019 16:04- by: LA County APEX
20-Mar-2019 06:21
Oracle Apex 18 Interactive Grid: Actions - Selection - Fill and Copy Down issue
1 replies - last reply: 20-Mar-2019 10:07- by: Alexus67
Felipe Ryckew
19-Mar-2019 19:28
ORA-24247: network access denied by access control list (ACL)
2 replies - last reply: 20-Mar-2019 14:03- by: Pavel_p
19-Mar-2019 18:21
Error Message text color issue when Upgrade from 5.0.3 to 18.2
2 replies - last reply: 20-Mar-2019 18:10- by: Guest007
19-Mar-2019 15:36
how to apply column break and apply selection on radio button on recent created
4 replies - last reply: 20-Mar-2019 17:45- by: ReemaPuri
19-Mar-2019 11:31
Can we Display the output which we got from procedure in apex pages
5 replies - last reply: 19-Mar-2019 12:28- by: fac586
11-Mar-2019 18:02
Page Layout Columns Rows
13 replies - last reply: 20-Mar-2019 14:08- by: fac586
06-Mar-2019 08:56
Error on importing APEX App (ORA-01403: no data found,wwv_flow_api.create_translation)
0 replies
03-Mar-2019 10:51
Returning and displaying a value to the calling page from a modal pop-up
11 replies - last reply: 20-Mar-2019 10:14- by: fac586
16-Feb-2019 18:32
Work-around for Page Template Region Position 8 with Universal Theme
19 replies - last reply: 20-Mar-2019 08:31- by: Laury


Marc Sewtz    Other now on 19.1
16-Mar-2019 17:42:44 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: UK, Bognor Regis, permanent
20-Mar-2019 12:00:43 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Germany, Hamburg, permanent, onsite
19-Mar-2019 19:58:25 by: Juergen Schuster
Carsten Czarski  
Loading data in existing tables with 19.1
APEX 19, Data Loading, Excel
18-Mar-2019 17:34:31 by: Juergen Schuster
Jeffrey Kemp  
Workspace Manager, VPD and APEX
18-Mar-2019 00:26:11 by: Juergen Schuster
Jaydip Bosamiya  
Custom is_authorized function
14-Mar-2019 09:10:25 by: Juergen Schuster
GPM Factory France    
New Plug-in: Resource Diagram
14-Mar-2019 02:59:02 by: Maxime Tremblay
Denes Kubicek    Other will be upgraded to 19.1 on March 15
13-Mar-2019 21:14:06 by: Juergen Schuster
Roel Hartman  
Filtering in Interactive Grid
Interactive Grid
12-Mar-2019 18:09:43 by: Juergen Schuster
Roel Hartman    
New Plug-in: Interactive Grid, add and delete filters
Interactive Grid, Plug-ins
12-Mar-2019 14:50:26 by: Juergen Schuster
Carsten Czarski  
Super-Easy CSV, XLSX, JSON or XML parsing
11-Mar-2019 14:29:21 by: Maxime Tremblay
Joel Kallman    Other runs now on 18c
09-Mar-2019 20:06:12 by: Juergen Schuster
Maxime Tremblay  Other
New Job: Oracle, India, New Delhi, Permanent, Onsite
08-Mar-2019 14:02:52 by: Maxime Tremblay
Jackie Mcilroy    Other
New Podcast: New Jobs for Everybody! #LowHighPodcast
07-Mar-2019 23:22:27 by: Jackie Mcilroy
Ronny Weiß    
New Plug-in: Everything you want from a Rich Text Editor
Plug-ins, Rich Text Editor
07-Mar-2019 20:32:14 by: Juergen Schuster
Trent Schafer  
Formatting Datepicker as Uppercase
07-Mar-2019 00:00:40 by: Maxime Tremblay
Peter Raganitsch  
Tomcat Reverse Proxy APEX and ORDS
Installation, ORDS
06-Mar-2019 23:48:55 by: Maxime Tremblay
Joel Kallman  
Quick SQL
Quick SQL
06-Mar-2019 19:31:52 by: Maxime Tremblay
Angel Flores Torres  
Installing APEX on XE on Windows
Installation, XE
06-Mar-2019 19:27:56 by: Maxime Tremblay
Jackie Mcilroy    Other
Live #LowHighPodcast: March 7th, 12pm ET, join and participate
20-Feb-2019 14:38:59 by: Jackie Mcilroy
Marc Sewtz  Other
Office Hours: Social Login, March 7th
05-Mar-2019 01:37:42 by: Maxime Tremblay
Hilary Farrell  Other
New Job Offer: Oracle, APEX Dev Team, Continuous Integration, permanent
06-Mar-2019 10:33:32 by: Juergen Schuster
Carsten Czarski  
Report and Form on a REST Service
05-Mar-2019 01:33:18 by: Maxime Tremblay
Paul Jones    Other
Video: Choosing the Right Report
Reports, Videos
05-Mar-2019 01:30:28 by: Maxime Tremblay
Maxime Tremblay  Other
New Job Offer: Oracle, India, Karnataka, Bangalore, Permanent
04-Mar-2019 14:03:40 by: Maxime Tremblay
Adrian Png    Other
Member of the Month, February: For his incredible APEX Challenge Coins and 2 great Blog Posts
Member of the Month
03-Mar-2019 18:59:17 by: Maxime Tremblay
Adrian Png  
Oracle Cloud for APEX - Part 2
Cloud, Hosting
03-Mar-2019 18:46:35 by: Maxime Tremblay
John Snyders  
Mega Menus
03-Mar-2019 18:45:01 by: Maxime Tremblay
Ming Lei  Other
New Job Offer: Canada, Quebec, Longueuil, permanent, onsite
02-Mar-2019 01:49:37 by: Maxime Tremblay
David Anderson    
New XE APEX Hosting
Hosting, XE
02-Mar-2019 01:40:55 by: Maxime Tremblay
Matt Nolan    Other
New Podcast: Matt Nolan, 150 Plug-ins
01-Mar-2019 20:16:30 by: Juergen Schuster
Dimitri Gielis  
Images in Emails
Email, Images
01-Mar-2019 11:58:41 by: Maxime Tremblay

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20