Slack

@p.ettinger Well, you can check if you have "Plain Text" (instead of Text Field) in the Identification (Column) Type.
26-Aug-2016 09:37:PM by: gaspar
I'm reading the APEX doc about Tabular Forms over and over again. But i can not figure out, how apex decides if a column is shown as readonly. i mean without using javascript. can anybody point out which property in the page designer is to be set? i did create the page using the wizzard, and chose 2 columns not to be editable. it works when the page is run. but where is the information stored so that i could edit some more columns to be readonly.
26-Aug-2016 02:31:PM by: p.ettinger
@trent thank you. It works perfectly!!
26-Aug-2016 01:56:PM by: souven
I use this method by @joelkallman http://joelkallman.blogspot.co.uk/2014/03/yet-another-post-how-to-link-to.html
26-Aug-2016 01:44:PM by: turntablez
refresh a page item
26-Aug-2016 01:20:PM by: mecedar
Hallo, Somebody know how to print Jasper report in Apex and then redirect the Page?? I can print but the redirect Page don't work
26-Aug-2016 09:01:AM by: pierre
Of course, assuming you use APEX auth and not your own custom auth scheme
26-Aug-2016 07:51:AM by: trent
@souven: Have you come across the apex dictionary? There is a wide array of view you can pull useful info from
26-Aug-2016 07:47:AM by: trent
@art.rinberger thank you very much it works perfectly! but I have other question. Do you know how can I get the other information of the user? for example Name and Last Name
26-Aug-2016 02:45:AM by: souven
@souven: It's one of the built-in substitution strings. See https://docs.oracle.com/cd/E59726_01/doc.50/e39147/concept_sub.htm#HTMDB03023 for more information.
26-Aug-2016 01:25:AM by: art.rinberger
Hello everyone, Do you know how can I capture the user who is active in the session in APEX 5?
25-Aug-2016 09:01:PM by: souven
the default APEX 5 Tree looks uuuuuugly, anyone know of any alternatives? plugins?
25-Aug-2016 02:48:PM by: farzadso
Just tested this in APEX 5.1 EA, and the issue is still the same. I guess it is a browser limitation. Hence the message "Note: Some browsers will not allow a tab in another window to be focused if it is not the active tab. If this is the case you will have to manually switch to the application tab or window.". I use Chrome, and will just convince my colleges to switch to this instead :slightly_smiling_face:
25-Aug-2016 11:27:AM by: martinbnielsen
@p.ettinger Hi, There is a packaged app that does that, is called: Sample File Upload and Download Give it a try. You may have your answer right there! :wink:
24-Aug-2016 02:53:PM by: gaspar
OK, i got it working. Is a but cumbersome. Is it correct that only number PKs are allowed? We use GUIDS as technical PK. When using this i always get PL/SQL: numeric or value error: character to number conversion error :confounded:
24-Aug-2016 07:10:AM by: p.ettinger
Has anybody used the api function apex_util.GET_BLOB_FILE_SRC to download images in a report? i'm looking for a working demo. I read a whole lot of docs, but i can't get it working in my app.
24-Aug-2016 05:41:AM by: p.ettinger
Following on from this above I was having a moment of madness. Cup of coffee then realised I could just copy the template are reformat the divs some custom CSS and it works fine. What a dope
23-Aug-2016 01:51:PM by: lcw
Any kind souls fancy having a look at my query on APEX static regions and having a nice footer? https://community.oracle.com/thread/3964296 TIA
23-Aug-2016 01:38:PM by: lcw
Doesn't work in Brave, need to file a bug report.
23-Aug-2016 10:00:AM by: trent
On that topic, im lazy. Does APEX use the focus() call to switch tabs between designer and running page? e.g. var runPage = window.open('f?p=xxx'); runPage.focus(); runPage.opener.focus(); or some other crafty business?
23-Aug-2016 09:59:AM by: trent
Hi. We have problem working in IE when switching between developer page designer (APEX5) and run mode. The tab in IE is not changing automatically. Any ideas ? Thanks
23-Aug-2016 09:54:AM by: martinbnielsen
@juergen.schuster Okay thank you....
22-Aug-2016 12:08:PM by: ketan_madhak1191
@ketan_madhak1191 I guess you have to dye one death :slightly_smiling_face:. If it is just one item, I would put it in a hidden region and move it with jQuery after page load :wink:
22-Aug-2016 11:53:AM by: juergen.schuster
When i try to TEST web service from Hosted Environment(server - Apex 5.0.4) HOST name changes into IP address how can i make it stable. Like http://apex.world.com|apex.world.com does!! i want to generate https://myhost:9091/apex/test/hr instead it changes into https://127.1.1.10:9091/apex/test/hr how can we control this
22-Aug-2016 09:33:AM by: pranav
@juergen.schuster using display image item i can easily fetch the blob data from collection using BLOB column returned by SQL statement
22-Aug-2016 09:15:AM by: ketan_madhak1191
@ketan_madhak1191 I would leave APEX out of the equation, just do a htp.p() and output the image in the <img>
22-Aug-2016 09:11:AM by: juergen.schuster
@juergen.schuster actually page item is of type display image and i want to display that image into canvas which is in region type pl/sql.
22-Aug-2016 09:00:AM by: ketan_madhak1191
@ketan_madhak1191 I don’t think so, how should APEX know at design time what you will create dynamically at run time? The best approach I could think of, is generate the items in a hidden regions and move them to the new region with jQuery and show them or you simply use apex_item.xxx
22-Aug-2016 08:56:AM by: juergen.schuster
I have dynamically generated html div in region type pl/sql. Can we set position of page item inside that dynamically generated html div?
22-Aug-2016 07:18:AM by: ketan_madhak1191
thank you @matze276 it works by apex_util.prepare_url :simple_smile:
21-Aug-2016 06:37:AM by: iamasgor
two options there: 1. simple checkbox plugin: https://apex.oracle.com/pls/apex/f?p=654321:206:::::: 2. add an item computation process to set 0 value: nvl(:ITEM, 0)
20-Aug-2016 05:20:PM by: menno.hoogendijk
Does anyone know how to create checkbox based on 1/0 values? I've created one but I always got "null" in unchecked state
20-Aug-2016 12:36:PM by: vladml
Thank you @maxime_tremblay . I solved it Putting the Cascading LOV Parent Item
19-Aug-2016 06:26:PM by: souven
@souven are trying to clear the selected value of the coresponding lov? if that'S the case, you could simply use the set value action and set it to null
19-Aug-2016 06:22:PM by: maxime_tremblay
@swesley_perth it seems like 99% of our sessions had timed out and purging them simply didn't work, i deleted my configuration folder, uninstalled ORDS from the database, reinstalled it
19-Aug-2016 05:01:PM by: farzadso
got an error use data reporter when creating new report: unable to create INITIAL extent for segment in tablespace APEX_25617856675803632344 Can someone help? Thanks!
19-Aug-2016 02:47:PM by: mecedar
apex.world is facing issues, we are working on it
19-Aug-2016 10:03:AM by: juergen.schuster
getting errors when trying to edit an already inserted info
18-Aug-2016 03:25:PM by: daveblezz
@iamasgor: It should work the same way with apex_util.prepare_url. Usually the first column in your SQL is the link column
18-Aug-2016 02:44:PM by: matze276

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
M.Emmanuel
28-Aug-2016 21:11
Display a retrieved number with leading zeros in a form
Link
5 replies - last reply: 28-Aug-2016 23:08- by: Pranav.shah
Regis GILOT (
28-Aug-2016 20:30
Problem for translation when using "Override User Interface Level" on a page
Link
0 replies
M.Emmanuel
28-Aug-2016 19:20
Tree element, clickable elements
Link
1 replies - last reply: 28-Aug-2016 20:03- by: fac586
b40c1467-11ea
28-Aug-2016 17:04
Software for MAC
Link
0 replies
4e0e8b64-ce26
28-Aug-2016 15:31
Not able to send SMS through APEX
Link
2 replies - last reply: 28-Aug-2016 23:51- by: swesley_perth
3295880
28-Aug-2016 11:46
Problem with Apex 5.0 with older theme to keep list at right side of the window
Link
0 replies
3242070
28-Aug-2016 09:10
Hand over the Row ID Intractive Report
Link
1 replies - last reply: 28-Aug-2016 20:46- by: Pranav.shah
3231030
27-Aug-2016 21:27
Integration html5 website in apex5
Link
0 replies
Laury
27-Aug-2016 18:52
How to get the color of the text of form-field depending on the value of another field?
Link
3 replies - last reply: 28-Aug-2016 10:30- by: Laury
2727565
27-Aug-2016 10:58
Apex.server.process ajax request size limit. APEX 5.0, Oracle 11g, 12c.
Link
0 replies
User568670-OC
27-Aug-2016 01:42
Timestamp and username need to store in APEX
Link
2 replies - last reply: 27-Aug-2016 15:51- by: XeM
Jeannie
26-Aug-2016 23:49
Need to format IR heading row to group two sets of radio buttons
Link
2 replies - last reply: 28-Aug-2016 23:48- by: swesley_perth
Keegan_W
26-Aug-2016 15:32
Drill down stacked bar chart pass filters to IR
Link
1 replies - last reply: 27-Aug-2016 02:13- by: Mahmoud_Rabie
inka
26-Aug-2016 12:52
Update of Tabular Form
Link
1 replies - last reply: 27-Aug-2016 02:04- by: Mahmoud_Rabie
Pavel_p
26-Aug-2016 12:47
Call REST services at apex.oracle.com
Link
1 replies - last reply: 27-Aug-2016 01:40- by: Mahmoud_Rabie
BhardwajRavi
26-Aug-2016 11:02
Getting Error while downloading IR to Excel
Link
3 replies - last reply: 29-Aug-2016 04:52- by: BhardwajRavi
BhardwajRavi
26-Aug-2016 10:44
Getting error in IR pagination (APEX)
Link
3 replies - last reply: 29-Aug-2016 04:54- by: chajlk
Hien
26-Aug-2016 07:16
Need help on removing Modal Dialog [x]
Link
4 replies - last reply: 28-Aug-2016 23:31- by: Hien
Alacri-t
25-Aug-2016 14:25
Apex 5 - Change Error Page Icon
Link
2 replies - last reply: 28-Aug-2016 12:19- by: Alacri-t
salute-Salem
25-Aug-2016 10:37
Adding display column to a Detail Region
Link
4 replies - last reply: 28-Aug-2016 21:06- by: Pranav.shah
guest1991
23-Aug-2016 14:54
Sign Up Page with default Authentication
Link
9 replies - last reply: 29-Aug-2016 01:57- by: swesley_perth
Infantraj
27-Jun-2016 16:34
How to unlock apex.oracle.com account
Link
4 replies - last reply: 29-Aug-2016 04:45- by: Infantraj
nchasomeri
23-Jun-2016 11:51
Apex 5.0.3 Get an error when try to publish a translated application
Link
2 replies - last reply: 28-Aug-2016 20:36- by: Regis GILOT (MATIXA SNC)
M.Emmanuel
12-Jun-2016 08:15
Format a number field so it displays leading zeros (i.e. 0001 instead of 1)
Link
5 replies - last reply: 28-Aug-2016 21:58- by: M.Emmanuel
Lidagon
06-Jun-2016 16:03
Placing image in Nav Bar
Link
4 replies - last reply: 29-Aug-2016 00:31- by: Lidagon

News

X
    
 
X all
ImageNewsFavoriteMark read
Brendan Tierney  
How to get ORE to work with APEX
Link
27-Aug-2016 15:05:07 by: Juergen Schuster
X
Roel Hartman  
Creating an APEX Plug-in for a JET component Part2
JET, Plug-ins
Link
26-Aug-2016 18:37:32 by: Juergen Schuster
X
Martin D'Souza    Other
Kscope17 Early Bird rate expires at September 1
Conferences
Link
26-Aug-2016 18:19:45 by: Juergen Schuster
X
Monty Latiolais    Other
Oracle Open World 2016 - APEX Sessions
Conferences
Link
26-Aug-2016 16:21:30 by: Juergen Schuster
X
Scott Wesley    
Debugging in APEX
Debugging
Link
25-Aug-2016 08:36:59 by: Juergen Schuster
X
Christian Rokitta    
New Plug-in: Show Cookie Tracking Message
Cookies, Plug-ins
Link
23-Aug-2016 10:44:01 by: Juergen Schuster
X
Dan McGhan  
Working with Dates in JavaScript, JSON, and Oracle DB
JSON, JavaScript
Link
22-Aug-2016 20:02:35 by: Juergen Schuster
X
Roel Hartman  
Creating an APEX Plug-in for a JET component
JET, Plug-ins
Link
22-Aug-2016 08:45:41 by: Juergen Schuster
X
Juergen Schuster  Other
New Job Offer, UK, Leeds, permanent
Jobs
Link
19-Aug-2016 14:23:47 by: Juergen Schuster
X
Juergen Schuster    Other
New apex.world version with APEX Quiz statistics. Time to beat Scott Wesley!
Quiz, apex.world
Link
19-Aug-2016 10:32:35 by: Juergen Schuster
X
Jon Lingard  
What you need to know about the Oracle Cloud
Cloud
Link
19-Aug-2016 09:37:12 by: Juergen Schuster
X
Monty Latiolais    Other
New Podcast: Monty Latiolais at Kscope16 Chicago
Podcast
Link
18-Aug-2016 19:55:29 by: Juergen Schuster
X
Juergen Schuster    Other
New Conferences in UK, Latin America and Australia
Conferences
Link
18-Aug-2016 15:48:27 by: Juergen Schuster
X
Jorge Rimblas  
Video Seminar Drag & Drop in APEX
Videos
Link
18-Aug-2016 14:13:50 by: Juergen Schuster
X
Monty Latiolais  
Structure your APEX Workspaces
Admin
Link
17-Aug-2016 22:55:57 by: Juergen Schuster
X
Craig Sykes  
Chunked File Up- and Download
File Upload
Link
17-Aug-2016 14:27:01 by: Juergen Schuster
X
Jorge Rimblas  
Implementing Drag & Drop in APEX
jQuery
Link
17-Aug-2016 12:34:51 by: Juergen Schuster
X
Jeffrey Kemp  
Sending SMS, MMS and Voice Messages
API, PL/SQL
Link
17-Aug-2016 12:31:30 by: Juergen Schuster
X
Richard Martens    
New Plug-in: Cascading LOVs in Tabular Forms
Plug-ins, Tabular Forms
Link
15-Aug-2016 21:18:50 by: Juergen Schuster
X
Nick Buytaert  
Rethinking navigation in APEX
Link
15-Aug-2016 19:58:45 by: Juergen Schuster
X
Joel Kallman    
APEX App: Water resources data portal
Applications
Link
15-Aug-2016 19:53:43 by: Juergen Schuster
X
Aaron Wade    
Running a small Business with APEX
Applications
Link
15-Aug-2016 14:04:19 by: Juergen Schuster
X
Morten Braten  
Using PayPal REST API from PL/SQL
PL/SQL, REST
Link
15-Aug-2016 06:32:57 by: Juergen Schuster
X
Roel Hartman  
Consuming REST using JSON in APEX
JSON, REST
Link
15-Aug-2016 06:29:44 by: Juergen Schuster
X
Menno Hoogendijk  
Structure JavaScript code in your APEX App
JavaScript
Link
15-Aug-2016 06:10:55 by: Juergen Schuster
X
Joel Kallman    Other
Climate Change Portal in APEX
Applications
Link
14-Aug-2016 11:40:21 by: Juergen Schuster
X
Juergen Schuster    Other
SQL in you Word Document and use it in APEX
Product
Link
14-Aug-2016 11:35:50 by: Juergen Schuster
X
yotti Alli Pierre  
Integrating a basic calculator into APEX
JavaScript
Link
11-Aug-2016 07:23:08 by: Juergen Schuster
X
Christian Klingbacher    Other
New Meetup in Graz / Austria
Meetups
Link
10-Aug-2016 19:47:56 by: Juergen Schuster
X
Monty Latiolais    
Why APEX
Press
Link
10-Aug-2016 19:31:56 by: Juergen Schuster
X
Martin D'Souza  Other
New APEX Quiz is out: Do you know your Dynamic Actions?
Quiz
Link
10-Aug-2016 15:11:26 by: Juergen Schuster
X
Joel Kallman  Other
Deprecated Features in 5.1
APEX 5.1
Link
09-Aug-2016 20:11:49 by: Juergen Schuster
X

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20