Hello, I have to maintain an application developped sometime ago in apex 4.2 and when I run the app from apex builder I don't see the developer toolbar at the bottom of page. I have checked the template and the substitution string `#DEVELOPER_TOOLBAR#` is there. Also there is no specific code to hide it; somebody has an idea how this can be hidden in execution? Thanks
16-Jan-2017 08:50:PM by: eureka7
For Interactive grids in 5.1 is there an option to refresh the entire report instead of just the submitted row?
16-Jan-2017 04:40:PM by: vito.campanelli
Hi, I am trying to use a procedure which calls APEX_MAILS.SEND to send mails on click of a button. I am passing the primary_key value through the procedure. this primary key value determines the value of the receiver. Any idea on how to implement it?
16-Jan-2017 03:35:PM by: sonikabmishra
Yes, I have read through that, which is why APEX v4.2 was configured pointing towards the CDB as I expected it to be able to access schemas within the PDB as well. The username I choose was just `APEX_TEST` which I confirmed wasn't already in use.
16-Jan-2017 02:59:PM by: chrisleopard
That looks like it's an issue with the username you chose
16-Jan-2017 02:56:PM by: lancem
I tried to create a new workspace with a new schema, but it errored at the end with what looks like a permissions issue: `ORA-20987: APEX - Unable to create user`
16-Jan-2017 02:55:PM by: chrisleopard
I've not tried using a PDB but... Have you read that? It looks about right.
16-Jan-2017 02:55:PM by: lancem
@lancem I see some schemas, yes. They're schemas associated to the CDB$ROOT in 12c. The schema I want to use in within the PDB (I'm hoping that this makes sense, apologies if not!).
16-Jan-2017 02:54:PM by: chrisleopard
... I can see your issue is it's not there. ok do you see anything at all?
16-Jan-2017 02:52:PM by: lancem
@chrisleopard do createworkspace > add name > re-use schema: yes > use dropdown
16-Jan-2017 02:51:PM by: lancem
I've never tried that, but why would you use that workspace? Create a new workspace entirely. I would imagine you'll break something / it won't work as expected if you try and use the INTERNAL workspace for your app.
16-Jan-2017 02:49:PM by: lancem
@maxime_tremblay @lancem thanks for the help! so far, I'm signed in as the `ADMIN` user into the `INTERNAL` workspace and can see that there is a default workspace with the `APEX_040200` schema assigned. I've tried assigning a new schema to the `INTERNAL` workspace but the schema I want to use doesn't appear in the list and I've also tried creating a new workspace but the same issue arrises when I go to select an available schema.
16-Jan-2017 02:45:PM by: chrisleopard
@chrisleopard have a look at the "Workspace to Schema Assignments" to make sure that the workspace has the the schema assigned. You can access it from the internal workspace. Then make sure that the application is using the correct schema as its parsing schema.
16-Jan-2017 02:36:PM by: maxime_tremblay
I would imagine it's because the instance is looking at <WORKSPACE> username tables,views etc. rather than existing_user.tables.
16-Jan-2017 02:24:PM by: lancem
Hi all, I'm very new to Apex and I'm currently stuck on a problem. Essentially, I have a 12c database with schemas in the pluggable database that I want to work on in Apex. However, these schemas aren't accessible and I believe it could be because the listener is configured for the root container and not for the pluggable database. Not knowing how Apex works, could this potentially be a cause as to why I don't see the schemas I want to work on?
16-Jan-2017 02:06:PM by: chrisleopard
Hi! try this! Guess why! 'select * from dual connect by level <= 10 connect by level <= 1 connect by level <= 3;'
16-Jan-2017 01:22:PM by: kuz
Hello all. I am trying to implement a search field that searches across multiple tables and multiple columns. I was able to implement it using Oracle Text, however, I can only search for one term at a time. If I put more than one term in the search field, the query doesn't return anything. Has anyone implemented something like this? I know it's probably doable using INSTR but the reason why I am using oracle Text is because i want to be able to do fuzzy search.
15-Jan-2017 05:42:AM by: abul_feed
@eureka7: You might try using the #TIMING# substitution variable in the region footer (shows processed time per region). Or you can try to use the apex access logs (assuming logging is enabled) using a dynamic action after page load. But my first response (question) is: Why? What is the business value for this requirement?
14-Jan-2017 10:27:AM by: roelhartman
@eureka7 I'm pretty sure you can do a show time on page load.. and after processing do the math and show the results..
13-Jan-2017 08:18:PM by: gaspar
Hello there, I need to display at the bottom of the page, the elapsed time, in my case, the time it took a page to display/to load after I submit. how can I do that? I was thinking of setting an item to the actual time with seconds when I submit the page and do a DA after page load to get the time and then try to make the difference and display but then I want the format xx minutes : yy seconds Is there a simple and fast way to achieve that or a plugin maybe?
13-Jan-2017 07:04:PM by: eureka7
I raised an SR with oracle and this is what they came back with also :slightly_smiling_face:
13-Jan-2017 03:54:PM by: lancem
13-Jan-2017 03:50:PM by: lancem
@lancem See
13-Jan-2017 03:50:PM by: eberhje
The oracle documentation in the troubleshooting only has reverting to 4.2... is it the same to roll back to 5.0 just with the difference schemas?
13-Jan-2017 03:09:PM by: lancem What's the easiest way to roll back to 5.0 should my application not work in 5.1?
13-Jan-2017 03:03:PM by: lancem
Hi. Is it possible to make items in a dynamic list conditional? Navigation menu is based on dynamic list of 'Function returning SQL query', do I need to do that in the function itself?
13-Jan-2017 02:56:PM by: shaun.mauer
One feature I do miss in tabular forms is giving hidden columns a header - sounds contradictory but is helpful for developers who struggle trying to find out which columns must have a value. See below.
13-Jan-2017 01:33:PM by: franklin.jr
Hi. Is it possible to use substitution variables in the filter of an IR? Need to have an "All rows" and a "My rows" based on who is logged in. Want to save each one as different public reports. All rows wont have the filter, My Rows need to have the filter.
13-Jan-2017 09:33:AM by: shaun.mauer
Hi, I have an interactive report which has 2 APEX_ITEM.SELECT_LIST_FROM_LOV. One LOV has distinct 3 values and pne LOV has more than 20 values.. therefore I ma able to apply filter on the first one but not on the second column with more values in LOV.. Please help me to resolve this
13-Jan-2017 09:21:AM by: ritika
@pierre I would make a table to hold any metadata you have about the files, including the filename and location in the filesystem. With that information, you could create an interactive report that links directly to each file and gives your users a good way to search them without having to upload them to the database. You should be able to reference a file by prefixing the location and filename with file:/// I think.
13-Jan-2017 03:05:AM by: art.rinberger
In an Oracle APEX interactive report with search bar, is there a way for me to set one of the report columns as default on search text? If so, how can this be done?
12-Jan-2017 06:13:PM by: franklin.jr
@pierre I would do something crafty.. like call a Process that will look for the file(s) your user is looking for (as an argument), then invoke the .print() within the Windows OS (big assumption here). I don't know if that .print() function exists in *nix. What you can't do is access and print a file in the Browser without being previewed.
12-Jan-2017 04:07:PM by: gaspar
@svenweller thank you
12-Jan-2017 02:28:PM by: shaun.mauer
@shaun.mauer I did a similiar thing once. The base concept was to create a second list, that just is a select query on based upon the apex repository for the "master" list.
12-Jan-2017 02:25:PM by: svenweller
@matze276 The App is only to make for User Easy to print the File: Now The Users must go in the Directory and Search all the PDF File that he want to Print. That is not User Friendly. What iwant to achieve is that the Useres can only enter the Name of the PDF in a Textfield and then the APEX APP Look in the Directory and Print the File
12-Jan-2017 02:18:PM by: pierre
@pierre thats difficult because it hurts several browser security features. Some browsers seem to have workarounds for this. See It would be easier to fetch the files from the webserver or maybe even from the database server. You can however have the user upload the file first and then print it.
12-Jan-2017 02:18:PM by: svenweller
12-Jan-2017 02:12:PM by: matze276
@matze276 My Problem are : I have already PDF Files in a Directory in my Local System. This PDFs are too Much. I want to use Apex to select the File with the Right name a Print it
12-Jan-2017 02:10:PM by: pierre
@danielh made a presentation at DOAG about printing files as pdf and save it on a local computer with Electron.
12-Jan-2017 02:07:PM by: matze276
Somebody know how to print PDF File locate in my locate Computer Using APEX?
12-Jan-2017 02:01:PM by: pierre
Hi. I want to reuse the Desktop Navigation Menu to drive a Cards List Region, but would like to exclude the home page from the cards, but but in the menu If I put a condition on the list item based on "Not Current Page", then it doesnt display in the menu. Is there a way around this, how would I define the condition to only exclude when in the region and not in the menu?
12-Jan-2017 01:49:PM by: shaun.mauer
@bryan I am not really sure about this one, there should be before column API. Maybe have a look at example as an idea.
12-Jan-2017 01:42:PM by: lschilde

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
17-Jan-2017 03:21
APEX 5.1 Theme Roller Container Border Radius issue
0 replies
17-Jan-2017 01:42
Possible to add scroll bar on the top of the report list besides the one at the bottom?
1 replies - last reply: 17-Jan-2017 02:46- by: pkpanda
17-Jan-2017 01:36
Interactive Grids master detail view, assign master selected primary key value to a page item
0 replies
16-Jan-2017 21:41
Create Report using JSON that is not uniform
0 replies
16-Jan-2017 20:13
How to give a name to the primary report
1 replies - last reply: 16-Jan-2017 22:17- by: Helen21again
Umbdae Arthur
16-Jan-2017 19:17
Call RESTful service when button clicked?
1 replies - last reply: 16-Jan-2017 20:10- by: Pavel_p
Jose Aróstegu
16-Jan-2017 16:42
Theme Roller not showing color picker anymore
0 replies
16-Jan-2017 16:37
Apex export of copied application gets incorrect application_id
1 replies - last reply: 16-Jan-2017 16:43- by: Hilary Farrell-Oracle
16-Jan-2017 16:08
5.1 Collections?
1 replies - last reply: 17-Jan-2017 00:56- by: swesley_perth
Klaus Sch.
16-Jan-2017 15:38
Possible Bug with "D3 Collapsible Tree Chart" PlugIn in APEX 5.1
0 replies
16-Jan-2017 14:56
Apex 5 - Drill Down Link from IR Column to different page and back loses the IR Report View
0 replies
16-Jan-2017 14:49
The action can't be completed because the file is open in OracleService
0 replies
Sergey Nemets
16-Jan-2017 13:43
Bug. Apex 5.1. Session lifetime couldn't be more than 12 hours
1 replies - last reply: 16-Jan-2017 14:09- by: klacey
Blue Bird
16-Jan-2017 12:10
How to use custom Format Mask in interactive report?
2 replies - last reply: 16-Jan-2017 13:04- by: Blue Bird
16-Jan-2017 11:05
Possible Bug with Interactive Grid and Pipelined Function ?
2 replies - last reply: 16-Jan-2017 14:57- by: kgamble
16-Jan-2017 09:31
Switch item shown as select list after migration 5.0 -> 5.1
3 replies - last reply: 16-Jan-2017 12:25- by: Patrick Wolf-Oracle
Hasan Al Mamu
16-Jan-2017 06:11
How to write PL/SQL or JavaScript Code for Editable Interactive Grid?
3 replies - last reply: 16-Jan-2017 17:01- by: Hasan Al Mamun
15-Jan-2017 15:29
primary key values using plsql code in apex 5.1
5 replies - last reply: 17-Jan-2017 01:01- by: swesley_perth
13-Jan-2017 21:30
PDF report unable to open
3 replies - last reply: 16-Jan-2017 14:30- by: IQ
13-Jan-2017 19:25
Elapsed time for a page load
5 replies - last reply: 16-Jan-2017 15:03- by: Fofana
13-Jan-2017 15:42
howto: Reference a page item elsewhere on page without submitting first?
2 replies - last reply: 16-Jan-2017 16:54- by: Mint-Innit?
Jonatas Gomes
12-Jan-2017 20:48
Modal window/dialog error when press close button
6 replies - last reply: 16-Jan-2017 23:41- by: Jonatas Gomes
12-Jan-2017 10:15
Include the comma in value of a Select List
6 replies - last reply: 12-Jan-2017 18:51- by: fac586
28-Dec-2016 13:45
Migrate APEX Application from Oracle APEX 2.2.0 to Oracle APEX 4.2.5
3 replies - last reply: 16-Jan-2017 15:21- by: 3305285
05-Sep-2016 05:20
apex_workspace_activity_log purge rate
4 replies - last reply: 17-Jan-2017 02:58- by: swesley_perth


Maxime Tremblay    Other
Member of the Year 2016: For 20 Blog-Posts, 3 Plug-ins and lot's of help in Slack
Member of the Month
01-Jan-2017 13:19:27 by: Juergen Schuster
Dietmar Aust    Other
New Training: APEX 5.1, Franfurt, Germany
16-Jan-2017 09:39:48 by: Juergen Schuster
Cloud Nueva Austin  
Tuning Tomcat for ORDS / APEX
14-Jan-2017 22:04:50 by: Juergen Schuster
Tobias Arnhold  
Conditional exporting of report column
Interactive Report, Reports
13-Jan-2017 20:28:40 by: Juergen Schuster
Dick Dral    
New Plug-in: Draw your Time
13-Jan-2017 15:22:50 by: Juergen Schuster
Sven Weller  
Copy ACLs for APEX 5.1 Upgrade
APEX 5.1, Installation
11-Jan-2017 23:41:17 by: Juergen Schuster
Farzad Soltani  
Legacy jsTree Bug
Bugs, Tree
11-Jan-2017 23:38:01 by: Juergen Schuster
Tobias Arnhold  
A new years promise
11-Jan-2017 07:15:36 by: Juergen Schuster
Dick Dral    
New Plug-in: Copy to Clipboard
10-Jan-2017 19:09:22 by: Juergen Schuster
christina moore  
Accessibility in 5.1
APEX 5.1, Accessibility
09-Jan-2017 19:06:29 by: Juergen Schuster
Dick Dral    
New Plug-in: Dynamic Resize of Dialogs (working in 5.0)
08-Jan-2017 12:45:11 by: Juergen Schuster
John Snyders  
All about column widths and heights in Interactive Grid
Interactive Grid
07-Jan-2017 10:04:42 by: Juergen Schuster
Jason Straub  
Downgrade to 5.0
APEX 5.0, APEX 5.1, Installation
07-Jan-2017 00:34:41 by: Juergen Schuster
Martin D'Souza    
Where to put global JavaScript files
07-Jan-2017 00:24:39 by: Juergen Schuster
christina moore  
Sync APEX REST Services from Dev to Prod
07-Jan-2017 00:20:08 by: Juergen Schuster
John Snyders  
Get Data In and Out of Modal Dialogs
Modal Page
07-Jan-2017 00:12:43 by: Juergen Schuster
Anton Nielsen  
ORDS Quirks - Where to put Slashes
05-Jan-2017 10:36:51 by: Juergen Schuster
Daniel Hochleitner    
First 5.1 Plug-in: Enhance Grid Menu
Interactive Grid
04-Jan-2017 12:12:19 by: Juergen Schuster
Scott Wesley  
Escaping Special Characters
04-Jan-2017 08:13:43 by: Juergen Schuster
Monty Latiolais  
Manage Technical Debt with Oracle APEX
04-Jan-2017 08:06:29 by: Juergen Schuster
Steven Feuerstein  
Generalizing APEX LOVs
04-Jan-2017 07:55:47 by: Juergen Schuster
Ivan Sabolić    
New Plug-in: Fancy Date Time Picker
03-Jan-2017 18:36:30 by: Juergen Schuster
Mark Lancaster    
Why you should always read the most current docu
APEX 5.1
02-Jan-2017 13:08:20 by: Juergen Schuster
Cloud Nueva Austin  
Speed up your Inline Dialog
Modal Page
01-Jan-2017 17:29:26 by: Juergen Schuster
Juergen Schuster    Other
We got rid of deleting news (only 3% used it) to make it cleaner
01-Jan-2017 13:40:35 by: Juergen Schuster
Bartosz Ostrowski    Other
Member of the Month December for 3 amazing Plug-ins
Member of the Month
01-Jan-2017 13:16:39 by: Juergen Schuster
Dick Dral    
New Plug-in: Put a report into single columns
01-Jan-2017 13:13:26 by: Juergen Schuster
Dick Dral    
Font APEX much nicer than Font Awesome
26-Dec-2016 18:21:47 by: Juergen Schuster
Juergen Schuster    Other
Recorded On Air show with Sabine Heimsath is available
On Air
26-Dec-2016 09:47:48 by: Juergen Schuster
Jeffrey Kemp  
Open Card Links on a new page
24-Dec-2016 17:46:44 by: Juergen Schuster
Dick Dral  
Using APEX_MAIL outside of APEX
24-Dec-2016 17:39:45 by: Juergen Schuster
John Snyders    
Reactivate the old Component View in 5.1
APEX 5.1
24-Dec-2016 17:32:35 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20