Stack Overflow
Stack Overflow

Questions tagged [oracle-apex-19.1]

Oracle Application Express version 19.1 - released Mar 2019. Superseded in Nov 2019 by version 19.2.

Use this tag in addition to oracle-apex if your question is specifically related to Oracle APEX version 19.1.

154 questions
3
votes
1 answer

Oracle Apex - Interactive GRID Word wrap for headers and cells without HTML tag

I have an interactive grid in Oracle Apex tool. I need to wrap the heading without html tag. Is it possible to do a word wrap on headers and cells ?
Maya
  • 45
  • 1
  • 7
3
votes
1 answer

Oracle APEX - passing IG column value to javascript

I have an IG with a link column where the target is set to URL and I use it to call javascript. What I want to accomplish is whenever a link column is clicked, grab a value of another - hidden column and set a page item to that…
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
3
votes
1 answer

Oracle APEX - make a field conditionally required

I have an item that is displayed conditionally - based on another item selection. I want to make that item non-required when hidden. What is the best way to do that?
Coding Duchess
  • 6,445
  • 20
  • 113
  • 209
3
votes
0 answers

javascript compressing a chunked image file being uploaded to database

I am trying to upload an image file from Apex File browser, as image files are huge so I am using a Chunked upload technique to upload an image into the database. Everything is working fine as the chunked file is being used in Apex Collections to…
Bilal
  • 41
  • 2
2
votes
1 answer

Accessing protected restful webservice

I've created few Rest Web Services using oracle apex environment. And need to call it from different database schema. (For e.g. I've 2 schema's abc and xyz. And both have their own apex environments. API's are created on abc's apex environment. And…
Anand Jagtap
  • 113
  • 1
  • 9
2
votes
3 answers

Oracle Apex Reports causing performance issue

I'm creating an Interactive Grid report. I've a very complex sql query. It has 3 portions of SQL query and the syntax is like below. WITH QUERY1 AS -- QUER1 -- QUERY2 AS -- QUER1 -- QUERY3 AS -- QUER1 -- SELECT -- COLUMNS…
Anand Jagtap
  • 113
  • 1
  • 9
2
votes
1 answer

Oracle Apex - A lot of session with nobody user

I have a lot of session with nobody user. Any solution how stop this. Page 9999 is login page, page 2 is default (home page) after login.
user_odoo
  • 2,284
  • 34
  • 55
2
votes
1 answer

Popup the message on Oracle APEX based on the check oracle table

Here is my scenario: Entering some values on the forms. enter image description here On clicking Create, I want to check if the same data exists on the table. If exists, I want to popup the message as this value is already exists with Yes/No…
Vijayan Kumar
  • 21
  • 1
  • 4
1
vote
3 answers

CLOB variable gives "ORA-06502: PL/SQL: numeric or value error"

I'm creating a dynamic report on oracle apex. I've a very huge query and as per requirement any portion of the query can be returned. I'm using PL/SQL Function Body returning SQL query feature of IR. For that, I'm simply returning the output. Return…
Anand
  • 101
  • 13
1
vote
1 answer

item validation is not working properly in oracle apex interactive grid page

I have an interactive grid in APEX page under same region I have created an Item: "P300_ADD_MODIFY_REASON". I want to put a validation for that item, which when I did with a PLSQL expression (:P300_ADD_MODIFY_REASON is not null) and Server side…
Anshul Ayushya
  • 131
  • 5
  • 21
1
vote
1 answer

Oracle Apex set select list value in session state without submit page on change

How save selected value from select list in session state without submit page on change? Example work with submit page!
babayaro
  • 491
  • 3
  • 15
1
vote
0 answers

Download XMLTYPE data as XML file on Oracle Apex page

My view return XMLTYPE, DATA column contains xml documents. Is it possible on oracle apex page on button click, on page load or other way download this as eg. TEST.XML file When load query in classic report and set Atributes > Apperancees >…
babayaro
  • 491
  • 3
  • 15
1
vote
1 answer

How to add desired column in pl/sql parser?

The following code shows no syntax error but in report it rise an error which is: ORA-01722: invalid number select line_number, col002 , case when exists (select null from cdr_personal_info c where c.phone_no=col002 ) then 'Yes' else null end as…
Arifullah
  • 69
  • 7
1
vote
2 answers

Issues with Web source module POST request Oracle APEX

I am in the process of calling Okta API for Authentication "Primary Authentication" as shown in the pic below and I tested this using post man and it was working as expected with proper response. I am trying to integrate this API call out with APEX…
Ashlesh Kumar
  • 79
  • 8
1
vote
1 answer

Popup LOV disable through simple Dynamic Action works in Apex 4.2 but not in Apex 19.1

We are migrating applications from Apex 4.2 to Apex 19.1, where we found that Popup LOV is not getting disabled based on value in another field. And that simple Dynamic action works in Apex 4.2 As this is migration project I do not have to change…
Anshul Ayushya
  • 131
  • 5
  • 21
1
2 3
…
10 11