see Validation, but the are error !!
23-Feb-2019 12:30:PM by: ERICKP
23-Feb-2019 11:55:AM by: ERICKP
seen : workspace :WHISKY passw: CIFopfp2 LOGIN:PANGUERICK8@GMAIL.COM
23-Feb-2019 11:55:AM by: ERICKP
my solde requette is ( select Numcompte, (D-(R+A)) SOLDE from (select c.NCOMPTE Numcompte, sum( case when o.type_operation='D' then t.montant else 0 end) D ,sum( case when o.type_operation='R' then t.montant else 0 end) R ,sum( case when o.type_operation='A' then t.montant else 0 end) A from TOPERATION o, TCOMPTE c, TTRASACTION t where c.ncompte=t.ncompte and o.type_operation=t.type_operation group by c.NCOMPTE ) )
23-Feb-2019 11:53:AM by: ERICKP
HELLO, I have a problem on my application. I would like to create a validation on the item P9_MONTANT. WHO gives an error message if the amount withdrawn is greater than the amount Balance of the account X
23-Feb-2019 11:52:AM by: ERICKP
23-Feb-2019 10:13:AM by: maheshdm
Thanks mheshdm it got it. Updated page is given below
23-Feb-2019 07:48:AM by: AHSAN
Hello, i want to change the " heading of Navigation Bar " of apex page given below. Appreciate to guidance from you.
23-Feb-2019 04:50:AM by: AHSAN
Hello. When i export a classic report that has Totals on a Break Column, the exported file includes html tags, specifically around the heading total, for example <b>Major Category Total:</b>. this is something automatically applied and I don't have control over it. Is there anything I can do to strip the <b> </b> during the export process? Thank you
22-Feb-2019 11:29:PM by: abul_feed
Glad it worked
22-Feb-2019 11:07:PM by: maxime_tremblay
@maxime_tremblay ignore my earlier message figured it out. Thanks for the info
22-Feb-2019 10:16:PM by: pritham9
@maxime_tremblay thanks for the info getting this error cannot call methods on dialog prior to initialization; attempted to call method ‘open’ do i need to call it as part of div
22-Feb-2019 09:54:PM by: pritham9
in you case it would be ```$(this.affectedElements).dialog("open")``` having the affected element be the dialog region
22-Feb-2019 09:48:PM by: maxime_tremblay
you can either do ```openModal('region_static_id')``` or ```$("#" + region_static_id).dialog("open")```
22-Feb-2019 09:48:PM by: maxime_tremblay
@maxime_tremblay Thanks for that info. I have created a dynamic action for a button to open the region on click of button but it dosent work. In DA i am executing the java script code $(this.affectedElements).popup(“open”);
22-Feb-2019 09:34:PM by: pritham9
like this?
22-Feb-2019 08:03:PM by: maxime_tremblay
Hello all. Is there a way to open region has pop up on click of button. The button and region or on same page
22-Feb-2019 06:41:PM by: pritham9
hi all I have install oracle 18 c xe on centos with apex 5 on container xepdb1 and 'simple file upload download' apex demo app and need loading apps -6000 pdf files (from 1 mb to 10 mb - all format is pdf). Any try something like that? stability, speed, and other performances?
22-Feb-2019 07:46:AM by: nadrog
Hello all, I have two questions about APEX tree: 1. How can I locate a certain value in the tree and customize the display (bold or highlight etc...). I am searching the console to get the right selector. This `$("#requests-tree-id [aria-level=2]");` can only locate all the item on level 2 but how to specify 1 exactly and customize? 2. how can I collapse only the first 2 or 3 levels out of 6 because level 4,5,6 have a long list of elements and I want to hide them
22-Feb-2019 12:09:AM by: eureka7
Hi All. Is there a way to get Ldap group and store it in apex. My requirement is not to use app_user instead use ldap_group for authentication
21-Feb-2019 09:37:PM by: pritham9
I apologize for the non-APEX question, but I know we have a lot of experts out there who might be able to point me in the right direction. We have a Java program being called from a web browser. It makes a JDBC connection to run a packaged procedure in the Oracle DB. I need to access a browser cookie from within that packaged procedure and I'm running into all kinds of problems. In order to use the owa_cookie package to read the cookie, it looks like I need to run either owa.initialize() or owa.init_cgi_env() first or I get an ORA-06502 error. I don't get an error after initializing, but when I get the cookie into a variable like v_cookie, the value of v_cookie.num_vals equals zero (0). Anyone done this successfully? Have an example or a link to a solution?
21-Feb-2019 06:19:PM by: Shane Bentz
@steffi That's probably the reason then, i am using APEX 18. Thanks anyway :slightly_smiling_face:
21-Feb-2019 03:03:PM by: tmon
@tmon Hi! I'm using the after refresh event too, and fire on initialization = true. I haven't used in on Apex 18, only Apex 5. Which version do you use?
21-Feb-2019 02:09:PM by: steffi
@steffi Which event are you using in the dynamic action? I was trying to use this with 'after refresh' on IR but nothing happens.
21-Feb-2019 01:36:PM by: tmon
There is some info on Stripe Integration.
21-Feb-2019 12:41:PM by: Jason Aughenbaugh
Hello, someone has already tried to create a dynamic list with APEX 18.2, I tried for a while to display _*attribute1*_, but no results. *select level, label, target, attribute1 from xxx*
21-Feb-2019 11:03:AM by: Souleman
on Step 2 Generating Payment form
20-Feb-2019 08:05:PM by: Adeel
I ams tuck with this Gateway
20-Feb-2019 08:05:PM by: Adeel
any one who have experience in Payment Integration with Apex 18
20-Feb-2019 08:05:PM by: Adeel
Hi Every One
20-Feb-2019 08:04:PM by: Adeel
evening all - is there a way of finding the date when an app was created?
20-Feb-2019 06:55:PM by: NintenDad
I use it everyday... compile plsql and write some JavaScript...
20-Feb-2019 01:57:PM by: maik.michel
Hi, Is there any way to disable interactive grid edit mode via dynamic action? I have a dynamic action that refreshes an interactive grid whenever an item changes. If the user has enabled editing by double clicking an IG column the refresh errors out.
20-Feb-2019 11:26:AM by: Sorin
Hi All, I have 2 copy of application in development instance with different changes. Is there any way i can merge the changes of 2 application into 1 application?
20-Feb-2019 09:26:AM by: ashwinrao
Hi All, Is there any way to debug which apex page hangs a database? In database session i found one query which looks like DML process of page as there are bind variables like(:B1,:B2 and so on).
20-Feb-2019 05:57:AM by: Ketan
Ah yup. Well I pretty much never touch stored proc's in sql dev these days.. just develop in VSC, then compile directly. Have a number of co-workers doing the same. Running an anonymous block I switch into sql dev to run it
20-Feb-2019 01:49:AM by: trent
right I'm not concerned yet on the how to connect there's a few choices more trying to see how many folks use it and how right now.
20-Feb-2019 01:39:AM by: krisrice
I use it to compile code, wraps around sqlplus/sqlcl. But a mechanism to query the database would be neat. I know I can do that in my sqlplus wrapper, but some basic column sorting by UI would be cool imo. Also, I send the output to the task window, so sometimes the formatting might not be that great. I know if I used SQLcl `set sqlformat ansiconsole` it would format it better, but I tend to use sqlplus for compilation purposes
20-Feb-2019 01:29:AM by: trent
@maxime_tremblay (and @here) If you were to mate VSCode with SQL DEV (or probably a better example SQLcl) What would you want they love child to look like? What would you want to be able to do from within VSCode?
19-Feb-2019 11:10:PM by: doug.a.gault
Obviously not all of sqldev would make sense so trying to get to a decent list of things to add in
19-Feb-2019 09:19:PM by: krisrice
Yes Everyday
19-Feb-2019 09:18:PM by: maxime_tremblay
Anyone here use VSCode for sql/plsql development ?
19-Feb-2019 09:17:PM by: krisrice
Ok, but how would you that? In my case I call an ajax-callback-process, which in fact returns a generated URL. The URL is generated by apex_utl.prepare_url and opens a modal page... ?
19-Feb-2019 06:58:PM by: maik.michel
Have you tried the floating scrollbar plugin? We use it in interactive reports and our customers like it :slightly_smiling_face:
19-Feb-2019 04:29:PM by: steffi

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
23-Feb-2019 17:08
Prevent users from entering alphabets
0 replies
23-Feb-2019 11:55
Oracle Authentication And authorizaton.
1 replies - last reply: 23-Feb-2019 16:39- by: fac586
Omar Baig
23-Feb-2019 09:49
Stop editing in an Interactive Grid in an Oracle Apex
1 replies - last reply: 23-Feb-2019 11:20- by: fac586
22-Feb-2019 20:22
How do I reference a LOV shared component ID?
5 replies - last reply: 23-Feb-2019 10:42- by: fac586
22-Feb-2019 17:37
Apex sorry this page isn't available
8 replies - last reply: 22-Feb-2019 22:55- by: htmlDB
22-Feb-2019 17:24
Table Lookup - Cannot Select Column Name from Data Load Table Tab (Within Shared Components)
1 replies - last reply: 22-Feb-2019 19:45- by: LA County APEX
22-Feb-2019 15:52
interactivegridsave DA fire only on successful save
1 replies - last reply: 22-Feb-2019 20:02- by: melinda_f
22-Feb-2019 14:55
Clicking Into an IG Column that is Calculated Makes it Go To 0.00
0 replies
Angelo Lopez
22-Feb-2019 14:52
APEX 5 - Date Picker HTML5 format mask issue
0 replies
Abha G
22-Feb-2019 14:24
How to set the default number of rows in interactive grid in oracle Apex
0 replies
Blue Bird
22-Feb-2019 13:03
How to align number right in Display Only control?
2 replies - last reply: 22-Feb-2019 17:20- by: Blue Bird
22-Feb-2019 13:02
Apex SSO using IBM TIFM
0 replies
Omar Baig
22-Feb-2019 12:53
ORDER BY Clause in an Oracle Apex in an Interactive Grid
4 replies - last reply: 23-Feb-2019 11:37- by: fac586
22-Feb-2019 11:54
How to control interactive report columns width?
2 replies - last reply: 22-Feb-2019 14:37- by: Mint-Innit
22-Feb-2019 10:36
Apex 18.2 Popup LOV rendering issue IE vs Chrome
3 replies - last reply: 22-Feb-2019 14:05- by: mc7
22-Feb-2019 09:00
0 replies
22-Feb-2019 05:13
Oracle Apex does not work after migrating Oracle 11G XE to Oracle 18C XE in Windows 10 Pro
2 replies - last reply: 22-Feb-2019 16:11- by: rober584812
Tony F.
22-Feb-2019 01:55
Installing Oracle Database 18c XE and Oracle Application Express (XE Version)
1 replies - last reply: 22-Feb-2019 16:01- by: Mike Kutz
21-Feb-2019 19:43
What is the appropriate Apex Network Call out Setup?
4 replies - last reply: 22-Feb-2019 21:48- by: Mike Kutz
Libor Modrovs
21-Feb-2019 14:26
Filter in Interactive grid using the patameter from URL
3 replies - last reply: 22-Feb-2019 16:52- by: PMON
21-Feb-2019 13:29
3 replies - last reply: 22-Feb-2019 19:36- by: LA County APEX
Sushmitha Sun
21-Feb-2019 10:56
Request storage
3 replies - last reply: 22-Feb-2019 09:52- by: Hilary Farrell-Oracle
21-Feb-2019 04:06
apex18.2:How to change the border color of IG cells
5 replies - last reply: 22-Feb-2019 13:15- by: Franck N
07-Feb-2019 19:53
Badge Color Coding
20 replies - last reply: 22-Feb-2019 16:49- by: JasonSA
09-Jul-2013 13:21
blank report when using rtf report layout
2 replies - last reply: - by:


Jackie Mcilroy    Other
Live #LowHighPodcast: March 7th, 12pm ET, join and participate
20-Feb-2019 14:38:59 by: Jackie Mcilroy
Joel Kallman  
APEX World 2019
23-Feb-2019 16:51:05 by: Jackie Mcilroy
Dirk Strack    
New Plug-in: Upload CSV to Collection
22-Feb-2019 23:39:08 by: Juergen Schuster
Roel Hartman    Other
Video: Oracle Cloud for Dummies
22-Feb-2019 11:38:17 by: Juergen Schuster
Anthony Rayner  Other
Video Office Hours: Accessibility
Accessibility, Videos
22-Feb-2019 07:08:38 by: Juergen Schuster
Lino Schildenfeld  
Sort Interactive Grid Detailed View
Interactive Grid
22-Feb-2019 06:26:23 by: Juergen Schuster
Anton Nielsen  
Peer Code Review Slides & App
21-Feb-2019 04:02:29 by: Jackie Mcilroy
Matthias Range    
New Plug-in: Kanban Board
20-Feb-2019 14:31:52 by: Juergen Schuster
Jaydip Bosamiya  
Unlock your Workspace after 3 failed Password attempts
19-Feb-2019 09:11:20 by: Juergen Schuster
Rodrigo Mesquita    
New Plug-in: Enhanced Wizzard
19-Feb-2019 08:56:52 by: Juergen Schuster
Roel Hartman  
Supressing Change Event on Interactive Grid Column
Interactive Grid
18-Feb-2019 21:07:23 by: Juergen Schuster
Ronny Weiß    
New Plug-in: D3 Charts
Charts, Plug-ins
18-Feb-2019 21:05:08 by: Juergen Schuster
Jorge Rimblas  
Reset Button for Interactive Report
Interactive Report
18-Feb-2019 17:12:43 by: Juergen Schuster
Michelle Skamene  
Zendesk Integration
18-Feb-2019 17:11:16 by: Juergen Schuster
Carsten Czarski  
New Declarative Interactive Grid options
Interactive Grid
18-Feb-2019 11:53:30 by: Juergen Schuster
Adrian Png  
Scripts for building up a complete APEX Docker stack
Docker, Installation
17-Feb-2019 19:38:39 by: Juergen Schuster
Oliver Lemm  Other
Speed up Interactive Grid
Interactive Grid
15-Feb-2019 11:28:08 by: Juergen Schuster
Ronny Weiß    Other
New Meetup: Germany, Dresden
14-Feb-2019 10:51:34 by: Juergen Schuster
Joel Kallman  Other
4 New Job Offers: Oracle, APEX Dev Team, Evangelists, permanent, free location
13-Feb-2019 16:52:24 by: Juergen Schuster
Marc Sewtz  Other
New Job Offer: Oracle, APEX Dev Team, Full Stack Developer, permanent, free location
13-Feb-2019 12:51:57 by: Juergen Schuster
Lino Schildenfeld  
IG Detail View Bug in 18.2
Bugs, Interactive Grid
13-Feb-2019 03:28:09 by: Jackie Mcilroy
Michelle Skamene  
The APEX community rocks!
13-Feb-2019 03:16:17 by: Jackie Mcilroy
Anton Nielsen  Other
Consolidated Help Text
13-Feb-2019 03:12:51 by: Jackie Mcilroy
Tomas Vitasek  
Interactive Grid Calculations and Validations
Interactive Grid, Validation
13-Feb-2019 03:07:32 by: Jackie Mcilroy
Tim St. Hilaire  
Auth-N and Auth-Z Using Oracle Identity Cloud Service (IDCS)
Authentication, Cloud
13-Feb-2019 03:02:52 by: Jackie Mcilroy
Sylvain Martel  
Extending EBS Part 2
13-Feb-2019 02:53:12 by: Jackie Mcilroy
Niels de Bruijn  Other
New Job Offer: Germany, Frankfurt, permanent, MT-AG
12-Feb-2019 14:23:31 by: Juergen Schuster
Carsten Czarski  
19.1 new Forms functionality beyond REST
APEX 19, Form (APEX)
12-Feb-2019 10:34:23 by: Juergen Schuster
John Snyders  
New Inline Popup and Dialog Regions
APEX 19, Regions
12-Feb-2019 04:57:43 by: Jackie Mcilroy
Dimitri Gielis  
Display Content only when Logged in as Developer
Application Builder, Debugging
11-Feb-2019 03:13:05 by: Jackie Mcilroy
Marc Sewtz    Other
Video Office Hours: 19.1 New Features
APEX 19, Videos
08-Feb-2019 21:02:21 by: Juergen Schuster
Lino Schildenfeld  
Google reCAPTCHA v3
Authentication, Security
08-Feb-2019 16:06:41 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20