Slack

Thanks @roelhartman and @orcl_dpeake
19-Jan-2018 04:23:PM by: phanny
@roelhartman Since APEX 5.1 you can’t generate from the APEX Migration Project anymore. Uploading Forms is still useful for discovering and annotating business logic, especially the logic hidden in forms triggers
19-Jan-2018 02:59:PM by: orcl_dpeake
Don’t use the Forms conversion utility. At best it is crap. But usually it just doesn’t work and you’ll get errors. Just rebuild your Forms using the wizards. It’s more fun and the results are way better.
19-Jan-2018 11:21:AM by: roelhartman
Hi, I am trying to import Forms file menu in apex. After converted .mmb to xml and while uploaded it in apex. I got this error: ERROR IN PARSING XML: TXM0000_MMB.XML. any help? Thanks.
18-Jan-2018 11:21:PM by: phanny
it is a annoying they created a language called apex - should be easy to distinguish as it looks a bit like java language
18-Jan-2018 02:14:PM by: alunowen
My guess is this: You submit the page with an invalid value, your validation raises the error, which results in refreshing the page (to display the error). When the page is reloaded, the dynamic pl\sql is executed which also results in an error. Things you could do, - Change your validation to “PL/SQL Function Body (returning Boolean)“. If the value of the item is incorrect set the item to null and return false -add a server side condition to your report region. either the same condition that you have in the validation or use the “Inline Validation Errors NOT displayed” type (could pick other validation error though) -in the pl/sql of your report add a check to make sure that the value is valid (similar to using a server side condition on the region)
18-Jan-2018 12:35:PM by: maxime_tremblay
Cool, so just a naming thing then. Thank you
18-Jan-2018 12:27:PM by: shaun.mauer
Has nothing to do with “our” APEX.
18-Jan-2018 12:25:PM by: roelhartman
Salesforce has it’s own “apex” : https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_dev_guide.htm
18-Jan-2018 12:25:PM by: roelhartman
Arb question - Why when I google Apex stuff, does a whole bunch of SalesForce stuff come up? Does it use Oracle Apex in anyway, or is it just a coincidence that it is the same name?
18-Jan-2018 12:20:PM by: shaun.mauer
Hello apex beginner here, I was wondering if there is anyway around the order in which the PLSQL code in the classic report(based on PLSQL function) region and the PLSQL code in validation is evaluated. There are 3 parts in my page; a search region with a text field item, a classic report(based on PLSQL function) region which uses the text field items in the search region in its PLSQL code, and a validation that checks the values in the text field items. The text field item expects a maximum of 10 numeric characters(\d{0,10}). The classic report uses that value in the where clause to construct an sql query. The validation checks the text field item if it contains anything other than numeric characters. The problem occurs when multibyte characters(in our case, asian characters) come into play. When multibyte characters are inputted into the text field item, we get an error stating the "buffer is too short", and the error message states the error resides in the classic report(based on PLSQL function). Even if we have a validation checking for non-numeric characters. It seems to catch the classic report error first. Which leads to me to believe the PLSQL for classic report (based on PLSQL function) region is evaluated first. Yes, the problem can be solved by increasing the buffer size, but I'd hate to have to change all the other classic report(based on PLSQL function) regions. If changing the order in which the classic report's PLSQL and validation's code is evaluated is possible I would like to do that. thanks in advance :slightly_smiling_face: APEX v5.0.4 oracle 11g
18-Jan-2018 09:04:AM by: zootolo
Is there anyway to make a column visible or invisible based off a select list? I thought i figured it out but the report is not filtering right
17-Jan-2018 04:49:PM by: alatimore
Unfortunately APEX collections are what they are, and there is no way to extend the number of columns. Under the covers the values are stored in an APEX data Dictionary Table, so the definition is static. If you’re going over 50 character columns then you’re likely going to have to find another solution. When @sspendol and I were working on [SERT](http://www.oraopensource.com/apex-sert/) we ended up creating our own version of Collections for various reasons, including the limitation on the number and types of columns.
17-Jan-2018 01:19:PM by: doug.a.gault
@shaun.mauer I've only managed to do it with oos-utils. apex_util.set_security_group_id doesn't set g_curr_flow_security_group_id.
17-Jan-2018 01:07:PM by: mgoricki
or you could try the snippet from the APEX_MAIL in order to set the APEX context https://docs.oracle.com/database/apex-5.1/AEAPI/APEX_MAIL.htm#AEAPI341 ```for c1 in ( select workspace_id from apex_applications where application_id = p_app_id ) loop apex_util.set_security_group_id(p_security_group_id => c1.workspace_id); end loop;```
17-Jan-2018 12:31:PM by: maxime_tremblay
Have you guys tried using something like this: http://oos-utils.readthedocs.io/en/latest/oos_util_apex/#create_session-procedure So that you could create an APEX session in PL/SQL, then you could use the API
17-Jan-2018 12:30:PM by: maxime_tremblay
@mgoricki Did you ever find an alternate solution to you `APEX_UTIL.PREPARE_URL` forum question? Is the only option to still do it manually and grant execute to `APEX_050100.WWV_FLOW_SECURITY` to your user generating the URL? https://community.oracle.com/thread/4102805
17-Jan-2018 10:47:AM by: shaun.mauer
I need 1 info 10 days back i have created one webservice reference in Oracle Apex application Now i am going to check this reference ,unable to find it. No idea how it got disabled automatic. How i can see this reference now? Any Idea?
17-Jan-2018 08:57:AM by: sharma.harish1
I create dynamic action on selection change which execute this code: var gridView = apex.region("regionid").widget().interactiveGrid("getViews").grid; var records = gridView.model.getSelectedRecords(); var ids = records.map(function(r) { return gridView.model.getRecordId(r); } ); $s("P33_RESULT", ids.join(":")); Then on submit I create process which take this P33_RESULT item as colon delimted string.
17-Jan-2018 08:37:AM by: jovanaknezevic17
Hy @jovanaknezevic17 question is how do you wont to trigger that event ? With button ?.... To get selected rows you can use var widget = apex.region('emp').widget(); var grid = widget.interactiveGrid('getViews','grid'); var model = grid.model; var selection = grid.getSelectedRecords();
17-Jan-2018 08:13:AM by: grlicaa
thank you
17-Jan-2018 08:08:AM by: maik.michel
or model.isChanged()
17-Jan-2018 08:04:AM by: grlicaa
You can use : var widget = apex.region('emp').widget(); var grid = widget.interactiveGrid('getViews','grid'); var model = grid.model; model.getChanges()
17-Jan-2018 08:03:AM by: grlicaa
Hello Everyone, I am apex beginner. I am using apex collections for storing temporary data. But Apex Collection limits me to 50 columns in SELECT clause(p_c001 -p_c050). Is there is a way or alternative way to display more than 50 columns using APEX collections? Thanks in advance.
17-Jan-2018 07:55:AM by: paveengopal90
Hi, is there a way to check if an IG has modified records / was changed?
17-Jan-2018 07:25:AM by: maik.michel
Is there a character limit on plsql dynamic action ?? I am updating a hidden page item from a json clob. But I get numeric error. Also does apex_json also has the 32 k limit ??
17-Jan-2018 04:06:AM by: venkateshpr
hello, apex beginner here, I want to add an extra button on the datepicker calendar. Is the html for the datepicker calendar defined anywhere in apex? If not, is there a better way than to just use javascript on everypage to add the button for the datepicker calendar? thanks in advance :slightly_smiling_face: APEX v5.0.3 Oracle 11g
17-Jan-2018 02:51:AM by: zootolo
Well in case you haven't found yet, look at the attributes properties of the IG, under Edit you can select whether or not you allow the end-user to create, update or delete. Or just switch off the enabled option. :grinning:
16-Jan-2018 03:57:PM by: hhaenen
Hi everyone, I want to use IG and custom server process, but I only want to select rows, take PK and do something with another table. No create or update or delete with IG. With tabular form I can do this with :APEX$ROW_SELECTOR. and PLSQL process. Do you know how to do that?
16-Jan-2018 08:32:AM by: jovanaknezevic17
@shaun.mauer https://docs.oracle.com/database/apex-5.1/AEAPI/SPLIT-Function-Signature-2.htm#AEAPI-GUID-A476D7F6-902E-450E-9287-CBA0D046AED8
15-Jan-2018 07:42:PM by: pierre
https://docs.oracle.com/database/apex-5.1/AEAPI/SPLIT-Function-Signature-1.htm#AEAPI-GUID-3BE7FF37-E54F-4503-91B8-94F374E243E6
15-Jan-2018 07:41:PM by: pierre
Been reading through the Apex 5.1 docs, and I see that the `APEX_UTIL.STRING_TO_TABLE` and `APEX_UTIL.TABLE_TO_STRING` functions have been deprecated... What is the suggested replacement for it and are there any articles/documents with examples? https://docs.oracle.com/database/apex-5.1/AEAPI/STRING_TO_TABLE-Function.htm#AEAPI185 https://docs.oracle.com/database/apex-5.1/AEAPI/TABLE_TO_STRING-Function.htm#AEAPI186
15-Jan-2018 07:33:PM by: shaun.mauer
Hello, This is not a specific APEX question, I hope I am not breaking any rules by asking the question here. Inspired by @krisrice twitter post - How do you deploy database change? I started to look at Flywaydb. Is anybody here using it to manage database changes in their projects? If so, how has the experience been?
14-Jan-2018 08:40:PM by: vito.campanelli
Thanks.
12-Jan-2018 05:44:PM by: pc
Sorry, not that I know of.
12-Jan-2018 04:55:PM by: doug.a.gault

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Jibba Jabba
20-Jan-2018 17:51
Can't install Sample Database (packaged) Application - prerequisite permissions checks failed
Link
2 replies - last reply: 20-Jan-2018 18:42- by: Jibba Jabba
Jibba Jabba
20-Jan-2018 14:47
Can't create new workspace with new schema on Apex 5.1
Link
2 replies - last reply: 20-Jan-2018 18:31- by: Jibba Jabba
user11289265
20-Jan-2018 14:19
Get visible Columns/Cell Values from Interactive Grid
Link
1 replies - last reply: 20-Jan-2018 17:29- by: Alli Pierre Yotti
Kam_oracle_ap
20-Jan-2018 12:49
How to Fix target column in data loading?
Link
1 replies - last reply: 20-Jan-2018 21:26- by: PMON
Khalequzzaman
20-Jan-2018 04:43
Row sequence Reordering in IG
Link
0 replies
zycoz100
20-Jan-2018 02:44
Hi Experts ,need help solving this acl issue and thanks in advance.
Link
2 replies - last reply: 20-Jan-2018 09:25- by: Alli Pierre Yotti
DSteele41
20-Jan-2018 02:39
Run Report based on Selecting Report from Select List and Date Range
Link
3 replies - last reply: 21-Jan-2018 01:14- by: DSteele41
DSteele41
20-Jan-2018 00:45
Select List showing as LOVs with Scroll bar ?
Link
1 replies - last reply: 20-Jan-2018 02:20- by: DSteele41
Linda_Snani
19-Jan-2018 21:15
Apply authorization on new button in Interactive Grid toolbar
Link
2 replies - last reply: 20-Jan-2018 22:55- by: Linda_Snani
ToolTimeTabor
19-Jan-2018 18:47
How do you conditionally REDIRECT using PLSQL?
Link
9 replies - last reply: 19-Jan-2018 21:35- by: fac586
Chris Woltenb
19-Jan-2018 15:22
Modal Dialog to separate APEX application
Link
1 replies - last reply: 19-Jan-2018 19:34- by: Mahmoud_Rabie
Thirumalai V
19-Jan-2018 09:35
Switch value could not get in IG using JavaScript
Link
3 replies - last reply: 19-Jan-2018 16:26- by: Dharmendra Kumar-Oracle
3246924
19-Jan-2018 06:44
Sending email from APEX 5 trial version
Link
3 replies - last reply: 19-Jan-2018 18:57- by: InoL
user12046241
19-Jan-2018 05:55
Two Page Master Details like Lagcy Page (Master Details) in APEX
Link
1 replies - last reply: 19-Jan-2018 19:36- by: Mahmoud_Rabie
lastmanse
18-Jan-2018 16:42
Moving an XE 11g database from one computer to another
Link
2 replies - last reply: 20-Jan-2018 12:55- by: lastmanse
3333842
18-Jan-2018 16:10
Interactive Report: Blank Record Below Header
Link
11 replies - last reply: 19-Jan-2018 18:46- by: 3333842
Blue Bird
18-Jan-2018 08:33
How to dynamically filter column names in SQL statement?
Link
7 replies - last reply: 19-Jan-2018 19:45- by: VivRichards
melinda_f
17-Jan-2018 21:19
APEX popup LOV Microsoft Edge
Link
4 replies - last reply: 19-Jan-2018 20:09- by: melinda_f
TC-Army
17-Jan-2018 20:16
5.1.4 Interactive grid - How to handle multiple custom validation messages
Link
1 replies - last reply: 19-Jan-2018 20:36- by: Mahmoud_Rabie
Vipin Raj
17-Jan-2018 11:32
APEX Report printing with BI publisher
Link
3 replies - last reply: 20-Jan-2018 15:24- by: Vipin Raj
3491958
17-Jan-2018 05:45
Submit and redirect in APEX 5.1
Link
12 replies - last reply: 19-Jan-2018 20:19- by: Idkfa2
ToolTimeTabor
15-Jan-2018 19:12
SyntaxError. Invalid Character
Link
16 replies - last reply: 20-Jan-2018 12:45- by: Pavel_p
3465845
12-Jan-2018 21:10
APEX Charts problem
Link
1 replies - last reply: 20-Jan-2018 14:23- by: Mahmoud_Rabie
Soukaina IDRI
12-Jan-2018 11:39
How to create Next/Previous buttons from IG results
Link
5 replies - last reply: 19-Jan-2018 14:59- by: Soukaina IDRISSI
Runrig
05-Jan-2018 18:25
Interactive Grid Commit Handling after all Rows updated rather than each row
Link
4 replies - last reply: - by:

News

X
    
 
ImageNewsFavoriteForward
Peter Raganitsch  
Use / for REST Definitions with ORDS
ORDS, REST
Link
19-Jan-2018 13:33:41 by: Juergen Schuster
Juergen Schuster    Other
You need to upgrade to 5.1.4 for Oracle Critical Patch Update Jan / 2018
APEX 5.1, Security
Link
19-Jan-2018 10:35:17 by: Juergen Schuster
Raymond Allo  
Installation on Tomcat with ORDS
Installation, ORDS
Link
18-Jan-2018 14:17:56 by: Juergen Schuster
Tobias Arnhold  
Dynamic LOV with Pipeline function
LOVs
Link
18-Jan-2018 14:07:25 by: Juergen Schuster
Maxime Tremblay  
Change Buttons in APEX confirm dialog
Messages, Modal / Inline Dialog
Link
18-Jan-2018 14:03:44 by: Juergen Schuster
Juergen Schuster    Other
New Meetup: Germany, Kassel
Meetups
Link
17-Jan-2018 16:58:26 by: Juergen Schuster
Matt Mulvaney  
Tab Blocks for the Application Builder
Application Builder
Link
17-Jan-2018 13:41:20 by: Juergen Schuster
Sven Weller  
Logos and Icons
Font-Icons, User Interface
Link
17-Jan-2018 13:15:24 by: Juergen Schuster
Martin D'Souza  Other
Webinar: APEX API's on Thursday
API, Webinar
Link
16-Jan-2018 21:43:50 by: Juergen Schuster
Joel Kallman    Other
Scalability of an APEX App
Performance
Link
16-Jan-2018 17:24:52 by: Juergen Schuster
Joel Kallman  
Why submit abstracts to Great Lakes Oracle Conference (GLOC)
Conferences
Link
16-Jan-2018 17:08:25 by: Juergen Schuster
Lino Schildenfeld  
Upgrade Error ORDS 17.4 on Weblogic
Bugs, ORDS
Link
15-Jan-2018 17:07:00 by: Juergen Schuster
Juergen Schuster  Other
New Job-Offer: USA, Richmond, Contract, 250, on-site
Jobs
Link
12-Jan-2018 16:51:58 by: Juergen Schuster
Scott Wesley  
Data Driven Icons
Font-Icons, Reports
Link
12-Jan-2018 12:01:58 by: Juergen Schuster
COLIN ARCHER  
ORDS, OAuth2 & Web Services Part 3
OAuth2, REST
Link
11-Jan-2018 10:48:38 by: Juergen Schuster
Daniel Hochleitner    
apex.world: You can now sort Plug-ins to "Last Updated"
Plug-ins, apex.world
Link
11-Jan-2018 09:44:29 by: Juergen Schuster
John Keymer  
Machine Learning in APEX
Machine Learning
Link
10-Jan-2018 20:21:23 by: Juergen Schuster
Juergen Schuster    Other
New Live APEX Web-Class
Trainings
Link
10-Jan-2018 14:38:48 by: Juergen Schuster
Joel Kallman  
Unified Auditing in APEX
Link
10-Jan-2018 14:35:14 by: Juergen Schuster
Adrian Png  
SSO with SAML
Authentication, SSO
Link
10-Jan-2018 14:30:02 by: Juergen Schuster
Scott Wesley  
Modify JET Property at Runtime
JET
Link
09-Jan-2018 13:07:23 by: Juergen Schuster
Scott Wesley  
JET JavaScript Customisation
JET, JavaScript
Link
09-Jan-2018 13:05:34 by: Juergen Schuster
Mark Lancaster  Other
APEXExportSplitter deprecated in 5.1.4
APEX 5.1, Export
Link
09-Jan-2018 12:57:43 by: Juergen Schuster
Doug Gault  
APEX and Workflows
Workflow
Link
09-Jan-2018 12:54:46 by: Juergen Schuster
Mathias Magnusson    
Help Text as Modal Dialog
Help, Modal / Inline Dialog
Link
07-Jan-2018 23:37:14 by: Juergen Schuster
Pierre Yotti  
CSS classes from Universal Theme
CSS, Universal Theme
Link
07-Jan-2018 10:51:53 by: Juergen Schuster
Juergen Schuster  Other
New Job-Offer: Germany, Lykershausen, Contract, on-site
Jobs
Link
05-Jan-2018 11:15:18 by: Juergen Schuster
Mazin Abdulah  
APEX 5.2 Swagger Doc Generator
Swagger
Link
05-Jan-2018 11:05:51 by: Juergen Schuster
Ronny Weiß    
New Plug-in: Dynamic Tooltips
Plug-ins, Tooltip
Link
04-Jan-2018 21:49:09 by: Juergen Schuster
Juergen Schuster    Other
MOOC SQL Fundamentals, Free
Trainings
Link
03-Jan-2018 20:33:24 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #19 is out!
Newsletter
Link
03-Jan-2018 19:35:59 by: Juergen Schuster
Adrian Png  Other
APEX Extension for Visual Studio
Link
02-Jan-2018 23:43:39 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20