Stack Overflow
Stack Overflow

Questions tagged [oracle-apex-20.1]

Oracle Application Express version 20.1 - released Apr 2020. Superseded in Oct 2020 by version 20.2.

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

33 questions
2
votes
1 answer

How to reset list to blank using javascript in Oracle apex

I have a select list component in Oracle apex and one button Select list drop down as below values I can choose any one - A B C On button click I have written a java script if $('#P1_DROPDOWN').val() == 'A' { alert.message('A value is…
kiric8494
  • 195
  • 1
  • 7
2
votes
1 answer

Oracle APEX 20.1 :Unable to Import Applications

I have APEX 20.1 (recently upgraded from 19.1) on an On-premise DB. I am trying to import application using Export/Import Utility in Page designer. After dropping the application file to be imported into the file browse area, and on click of next I…
DeekuSen
  • 95
  • 2
  • 9
1
vote
0 answers

Error while installing APEX : existing state of package "APEX_200200.WWV_FLOW_SECURITY" has been invalidated

I was trying to install Apex in windows, when I faced this issue on execution of the below command. @apexins SYSAUX SYSAUX TEMP /i/ The issue obtained is: not ok 5 - Installing Package Specs (Runtime) | 1.15 # Message:…
Suraj Jeswara
  • 446
  • 2
  • 10
  • 23
1
vote
1 answer

Oracle Apex Select List LOV conditional query

I have an Editable Interactive Grid (for product_sale table) with a Select List (to select a product) in Oracle Apex 20.2 app. Currently I'm using below query to populate this list of values. SELECT productName,productId FROM product WHERE…
Bishan
  • 15,211
  • 52
  • 164
  • 258
1
vote
0 answers

How to open pdf in new tab oracle apex 20.2

I can successfully upload, download pdf files in blob column but I want it to be open in new tab, it opens on same tab. Column properties Type : Download BLOB, Content Disposition : Inline
Sajid Ullah
  • 13
  • 4
1
vote
1 answer

APEX 20.1 - Styling Column Group Heading of Interactive Grid

Does anyone have an example showing how column headings can be styled in an Interactive Grid? I would like the column headings in each of the 4 different Column Groups to have a different background color to make the groups more…
LG-C
  • 47
  • 6
1
vote
0 answers

Oracle-Apex: Dynamically redirecting from login button

The scenario I have implemented social authentication similarly to described by Dimitri Gielisin hist post "Facebook, Google and Custom Authentication in the same Oracle APEX 18.1…
Emu
  • 494
  • 6
  • 15
1
vote
1 answer

Understanding connecting to the database through SQLPLUS

when reading the Oracle APEX documentation, I did not understand the reason it asks to connect to the database through sqlplus using sqlplus /nolog then connect sys as sysdba. If it will eventually connect with sys as sysdba, why not doing it from…
Eslam
  • 323
  • 3
  • 20
1
vote
1 answer

oracle apex arabic characters not displaying properly in csv export

I have an Interactive Report with column having arabic Characters displaying well in the Report , however i am exporting the Reports into csv but the arabic characters turns to ????? in csv file , Any suggestions or workaround i may follow either at…
Adeel Aslam
  • 1,285
  • 10
  • 36
  • 69
0
votes
2 answers

How to upload file as blob to my table | Oracle Apex |

I have been trying since yesterday no where I am able to find a proper post how to upload file as blob to table. Below is my table : create table upload_file ( fileblob blob, filename varchar2(250), mimetype varchar2(250), createDate…
kiric8494
  • 195
  • 1
  • 7
0
votes
1 answer

How do I add validation to text area in oracle apex

I am feed up with this Oracle APEX application , their is no proper videos or documentation I have a Text area field and button On button click I have written a PL/SQL code to send mail Is their any way I can populate error / success message on…
kiric8494
  • 195
  • 1
  • 7
0
votes
0 answers

How to send multiple people the mail using UTL_SMTP

I have been trying so hard but not able to implement Any solution is great appreciated !!! I am using APEX 20.x I Built one form which as following content in it : textfiled , textarea , choosfile , button FROM EMAIL : TextFiled1 SUBJECT :…
kiric8494
  • 195
  • 1
  • 7
0
votes
1 answer

PLS-00306 : wrong number or types of arguments in call to 'SEND'

I am bit stuck with this not getting how do I fix the issue Below is my procedure written , need to send mail where I am using Oracle APEX 20.x My code : CREATE OR REPLACE PROCEDURE MYMAIL ( x_to IN varchar2, x_frm IN varchar2, x_sub IN…
kiric8494
  • 195
  • 1
  • 7
0
votes
0 answers

UTL_SMTP mail send with No subject , body

I am writing a code which sends mail but it does not display any details over my mail A blank mail is sent without any SUBJECT , BODY Code : CREATE OR REPLACE PROCEDURE MAIL_ME ( v_frm in VARCHAR2, v_msg in VARCHAR2, v_smtp_hst in…
kiric8494
  • 195
  • 1
  • 7
0
votes
1 answer

Oracle Apex: Can not call StaticID in Page's Inline CSS

I'm trying to touch up my Title Bar with some custom CSS. On the title region, I've set a static id of "Homepage-Title" Page Designer Showing Static ID. Then I went to the Inline CSS section of the page attributes and added this CSS which calls my…
LogicallyFunky
  • 61
  • 1
  • 9
1
2 3