Stack Overflow
Stack Overflow

Questions tagged [oracle-apex-5]

Oracle Application Express version 5.0, released April 2015. Last patch 5.0.4 released July 2016. Superseded in Dec 2016 by version 5.1.

Use this tag for questions likely to be specific to version 5.0. You probably want to add the tag as well.

711 questions
7
votes
4 answers

APEX 5 interactive report column order

I have an issue with changing interactive report column order. My APEX version 5.0.3.00.03. If i change order in Columns nothing change. If i change order in SqlQuery nothing change. If i change type of report (eg select classic report) and come…
DanBoc
  • 160
  • 1
  • 2
  • 9
7
votes
3 answers

How to Vary the width of Interactive Report Column in Oracle Apex 5

I have one simple Interactive report build in Apex 5.0. Its just simple plain statement pulling the data from table. I need to adjust the size of each column in the so that data properly appears in the report. Right now what is happening is that i…
Raj
  • 91
  • 1
  • 2
  • 3
6
votes
3 answers

Set value of Popup LOV with dynamic action

I try to set the value of a popup lov with a dynamic action "Set value" of type PL/SQL Function Body. This works with a select list, but not with a popup lov. How can this be done?
Stefanie
  • 65
  • 1
  • 1
  • 5
6
votes
0 answers

APEX 5.0.1 Interactive report header column alignment

in apex 4.2.3 : in apex 5.0.1 : ==> Why header alignment not center in apex5 ?
Sebri Zouhaier
  • 745
  • 7
  • 18
5
votes
1 answer

Oracle Apex - Virtual Column error raised

I am currently working in Oracle Application Express 18.1.0.00.45 and I am getting an error that I do not understand. I created an interactive grid using the following query: select periodic_topics_id, filter, topic, CASE WHEN LINK1 like '%116%'…
Katherine Reed
  • 301
  • 1
  • 7
  • 20
5
votes
0 answers

BI publisher - chart error in Oracle APEX output excel by using rtf template layout

BI Publisher Enterprice edition APEX 5, APEX 5.1 - integrated in BI Publisher through instances Microsoft excel 2013 I create bi publisher rtf template with chart for my reporting. Then I use it in APEX layout. But when I want to print this layout…
Ramin Darvishov
  • 1,043
  • 1
  • 15
  • 30
5
votes
2 answers

Execute query on active region

I have one page where i have about 8 tab region. Each region has a select statment. They are executed when accessing the page (page load) at the same time. Because i have 8 select statment that executes at same time it leads to pure performance. My…
user4226899
5
votes
0 answers

Is linking to private IR no longer possible in APEX 5?

In one of our APEX 5 applications, we're using a drop-down box that allows users to choose a target interactive report in the same application. The application then branches to the target page, and the report is displayed. In APEX 4, this works fine…
Frank Schmitt
  • 30,195
  • 12
  • 73
  • 107
5
votes
1 answer

Apex 5: Admin account is locked

For a long time, I worked on my own workspace. Now I want to create a new workspace, add new users, .... I login into admin account but the account is locked. I tried to change password and unlock account. After running the @apxchpwd.sql script.…
Quan Nguyen
  • 559
  • 4
  • 23
  • 47
5
votes
3 answers

Oracle Apex 5.0 - Display static image

I'm new to Oracle Apex and I'm really struggling how to display static images on a desktop application. I uploaded an image at Shared Components -> Files -> Static Application Files and was given the reference #APP_IMAGES#test.jpg In my application…
CrapDeveloper
  • 156
  • 1
  • 3
  • 9
5
votes
2 answers

Apex 5 : Dynamic action set page item value

When using the new apex 5 release I'm encountering the following issue: Can't get the value of page items through plsql: nv(:P2_TO, :P2_FROM) <<< DOESN'T WORK *I Yes P@_FROM exist and verified nv(:P2_TO, 'test') <<< DOES WORK I have tried this both…
user1035654
  • 181
  • 3
  • 4
  • 10
4
votes
3 answers

Oracle Apex - should I use Empty_BLOB() or null?

I am currently using Oracle Apex 5.1.2. I created a table in the database that contains a column that can hold a BLOB data type, a column for filename, and a column for MIME type. In my APEX application, I have a File Browse page item. The intent…
Katherine Reed
  • 301
  • 1
  • 7
  • 20
4
votes
1 answer

Oracle Apex: redirect to the page user requested after login

I am using Oracle APEX 5.0 on Oracle 12c. I have a situation where a user opens a link to an apex page from his email and he is redirected to the login page because there is no session exists. e.g. the link that user clicks…
Zahid Kareem
  • 55
  • 1
  • 5
4
votes
1 answer

Oracle Apex - Losing session state when I click on hyperlink that is supposed to direct me to different page in application

I am currently working in Oracle APEX version 5.1.2. I have created an interactive grid in my application that queries data from a table stored in the Oracle database. The data being queried is just several different URLs that refer to different…
Katherine Reed
  • 301
  • 1
  • 7
  • 20
4
votes
1 answer

oracle apex 5 - how to reorder pages in menu

I am dveloping an app in Oracle APEX 5. All of my pages have menu entry on the left-side menu, but the order of the pages in menu is different to the page numbers. Is there a way how to reorder pages in the menu?
JanFi86
  • 449
  • 10
  • 29
1
2 3
…
47 48