Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In


Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.


Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question.


Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

Oracle APEX Tutorials & Forum

Oracle APEX Tutorials & Forum Logo Oracle APEX Tutorials & Forum Logo

Oracle APEX Tutorials & Forum Navigation

  • Home
  • Oracle Apex
  • PL/SQL
  • SQL
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges
  • Home
  • Oracle Apex
  • PL/SQL
  • SQL

An active developer community you can depend upon!

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Create a new Account
  • New Questions
  • Most Answered
  • No Answers
  • Most Voted
  • Recent Posts

Discy Latest Questions

Tonny
Tonny

Tonny

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 27 Points
View Profile
  • 2
TonnyContributor
Asked: December 5, 2023

Use table with DBLINK and without DBLINK PL/SQL ORACLE

  • 2

Use table with DBLINK and without DBLINK I have a procedure to use with DBLINK but I also need to use it without DBLINK, I could duplicate the procedure and it is already solved. But I want to just have an Oracle pl/sql procedure that can be used with DBLINK and that can also be used without DBLINK Please can you help me. CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER) AS BEGIN UPDATE accounts@dblink_histo SET balance = new_balance WHERE acct_id = acct; COMMIT; END credit_account; I do not want to repeat the following procedure that does not have DBLINK CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER) AS BEGIN UPDATE accounts SET balance = new_balance WHERE acct_id = acct; COMMIT; END credit_account; How can I use the table with DBLINK and without DBLINK so as not to repeat another procedure? Do you help me please?  

dblink
  • 1
  • 37
  • 0
Answer
RD_DEVVBR
RD_DEVVBR

RD_DEVVBR

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
RD_DEVVBRContributor
Asked: December 3, 2023

how to access Excel tables?

  • 0

Hello, my boss asked me to carry out a task, but I have doubts, he asked me to create an application where I could edit the Excel table that was uploaded within the apex itself, and then be able to compare the previous table with a new one that was added later

apextabels
  • 1
  • 18
  • 0
Answer
atif24
atif24

atif24

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 1
atif24Contributor
Asked: December 1, 2023

How to display image in Bi Publisher report by querying from Oracle Apex

  • 1

I want to display image in BI Publisher report in MS Word. I am downloding query xml file from Oracle Apex. Like :- SELECT name, image FROM Image_table. When I upload sample xml in BI publisher it don't show any data. Any Idea how do it ??

apexbipublisher
  • 4
  • 117
  • 0
Answer
apex-learner
apex-learner

apex-learner

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
apex-learnerContributor
Asked: September 18, 2021

how to add date facet in faceted search

  • 0

Hi. How can I include DATE RANGE  search criteria in Faceted Search? (while I was trying, I am getting the following error. Facet is not supported for DATE or TIMESTAMP columns.) Thanks,  

apexfacetfaceted search
  • 3
  • 1k
  • 0
Answer
Jorge.criv
Jorge.criv

Jorge.criv

  • 17 Questions
  • 17 Answers
  • 0 Best Answers
  • 129 Points
View Profile
  • 0
Jorge.crivProfessional
Asked: September 16, 2021

How to call apex_mail.send from outside of apex 20?

  • 0

Can apex_mail.send be called from outside of apex 20?

apex_mail.send
  • 2
  • 335
  • 0
Answer
pavlos
pavlos

pavlos

  • 37 Questions
  • 107 Answers
  • 1 Best Answer
  • 376 Points
View Profile
  • 0
pavlosGuru
Asked: September 15, 2021

How to call ajax callback process in modal dialog page?

  • 0

Hi! I have page with ajax callback which is executed on button click (submit). After I move page to modal dialog, ajax callback doesn't work. How to use ajax callback in modal dialog page?  

oracle apex
  • 1
  • 131
  • 0
Answer
Jorge.criv
Jorge.criv

Jorge.criv

  • 17 Questions
  • 17 Answers
  • 0 Best Answers
  • 129 Points
View Profile
  • 0
Jorge.crivProfessional
Asked: September 11, 2021

How to save and remember user on login page ?

  • 0

How to save and remember user login page in Apex 20?

loginrememberuser
  • 2
  • 495
  • 0
Answer
shashi
shashi

shashi

  • 15 Questions
  • 22 Answers
  • 0 Best Answers
  • 130 Points
View Profile
  • 0
shashiProfessional
Asked: September 8, 2021

How to get confirmation message for Logout

  • 0

Hi sir ji,How to show confirmation message for logout/signout when the user clicks the signout button from navigation bar list and redirect to logout url. can u please suggest.

question
  • 3
  • 503
  • 0
Answer
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
  • 10 Questions
  • 6 Answers
  • 0 Best Answers
  • 85 Points
View Profile
  • 0
Ali AkbarProfessional
Asked: September 7, 2021

how can i send report direct on printer ?

  • 0

when i press button for print then report should be  send to directly on printer instead any popup/page . How can we achieve this using BI Publisher or Jasper Report . please share code whose attempted this one task. Thank You.

print
  • 1
  • 104
  • 0
Answer
Jorge.criv
Jorge.criv

Jorge.criv

  • 17 Questions
  • 17 Answers
  • 0 Best Answers
  • 129 Points
View Profile
  • 0
Jorge.crivProfessional
Asked: September 3, 2021

how to modify distance between lines in an apex 20 form

  • 0

I have a form to load data and there are several items, I put them one below the other and they take up a lot of vertical space, even more when working on a mobile device how to modify distance between lines in an apex 20 form ?  

apex20form
  • 2
  • 110
  • 0
Answer
Waseem
Waseem

Waseem

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 26 Points
View Profile
  • 0
WaseemContributor
Asked: September 2, 2021

Java call terminated by uncaught Java exception:

  • 0

Dear Sir, I am using oracle database 11gr2 to connect to gmail and read messages. but I facing this error while connecting to gmail. ORA-29532: Java call terminated by uncaught Java exception: javax.mail.MessagingException: Connect failed; nested exception is: java.io.IOException: Couldn't connect using "javax.net.ssl.SSLSocketFactory" socket factory to host, port: imap.gmail.com, -1; Exception: java.lang.reflect.InvocationTargetException ORA-06512: at "IMAGE.MAIL_CLIENT", line 16 ORA-06512: at "IMAGE.MAIL_CLIENT", line 35 ORA-06512: at line 2

mail_client
  • 1
  • 364
  • 0
Answer
pavlos
pavlos

pavlos

  • 37 Questions
  • 107 Answers
  • 1 Best Answer
  • 376 Points
View Profile
  • 0
pavlosGuru
Asked: September 2, 2021

How to escape "&" in checksum of URL?

  • 0

I am trying to escape & from the prepare_url function, I use URL as a public bookmark. For insatnce: APEX_UTIL.PREPARE_URL ( p_url => 'f?p=' || :APP_ID || ':1:'|| :APP_SESSION ||'::NO::P1_ID:'|| x.ID ||'', p_checksum_type => 'PUBLIC_BOOKMARK', p_url_charset => 'UTF-8')

oracle apexurl
  • 5
  • 262
  • 0
Answer
Yuri
Yuri

Yuri

  • 1 Question
  • 1 Answer
  • 0 Best Answers
  • 26 Points
View Profile
  • 0
YuriContributor
Asked: September 1, 2021

Confirm Question after validation and submit

  • 0

Hi, My workflow is: Press button "SAVE" Validation If pass then a submit processing A question "Do you want to send a mail?" If OK - to send mail. My problem is that Confirm Message is javascript. Where's a point of that in submit processing? Thanks

confirmprocessingsubmit
  • 2
  • 212
  • 0
Answer
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
  • 10 Questions
  • 6 Answers
  • 0 Best Answers
  • 85 Points
View Profile
  • 0
Ali AkbarProfessional
Asked: August 31, 2021

Weight Scale machine or Attendance machine with oracle developer 12c / 11g

  • 0

hi guys any one implemented / integrated Weight Scale machine or Attendance machine with oracle developer 12c / 11g. ?

attendanceweight scale
  • 1
  • 66
  • 0
Answer
Ali Akbar
Ali Akbar

Ali Akbar

  • Faisalabad, Pakistan
  • 10 Questions
  • 6 Answers
  • 0 Best Answers
  • 85 Points
View Profile
  • 0
Ali AkbarProfessional
Asked: August 31, 2021

ORA-20001: Query must begin with SELECT or WITH error

  • 0

syntax is ok but showing error "ORA-20001: Query must begin with SELECT or WITH error"

errorora-20001
  • 1
  • 757
  • 0
Answer
BENNETT
BENNETT

BENNETT

  • 1 Question
  • 6 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
BENNETTContributor
Asked: August 27, 2021

Generate from Interactive Report and Insert into DB Table

  • 0

Hello, I am using Oracle APEX 20.2 and am looking for a way to use an existing interactive report to generate a BLOB .csv file and insert it into a database table. I need to do this so I can query the file for an email attachment through send_mail, so there may be a better way to perform the action where data from an interactive report populates a .csv file and attaches it to an email and sends it. How would I do this?

blob
  • 10
  • 327
  • 0
Answer
ranu
ranu

ranu

  • 2 Questions
  • 4 Answers
  • 0 Best Answers
  • 32 Points
View Profile
  • 0
ranuContributor
Asked: August 26, 2021

how to select records in interactive grid on page load

  • 0

I want to select records on IG on page load through apex.region("S_KRAFTSTOFFE").call("setSelectedRecords",[$v('P17_BEZ_ID')]) wherein the 'P17_BEZ_ID' has value "'Super Plus 98','Super 95','Diesel','Super E10','Ad blue (Gebinde)','Autogas (LPG)'" My problem is because P17_BEZ_ID is a string i cannot directly assign to setSelected records Please see the attachment in short i want to assign a string "'Super Plus 98','Super 95','Diesel','Super E10','Ad blue (Gebinde)','Autogas (LPG)'" to an IG with each element of string as one row of the IG  

ig
  • 2
  • 849
  • 0
Answer
Bhavin
Bhavin

Bhavin

  • 5 Questions
  • 14 Answers
  • 0 Best Answers
  • 52 Points
View Profile
  • 0
BhavinProfessional
Asked: August 24, 2021

Preserve checkbox in an Interactive Report with Select All option

  • 0

Hello Sir, How can I preserve the checkbox in an Interactive Report with Select All option (eg, Report on EMP table). Once selected then need to load the selected rows into a new table (EMP_NEW). Your help and support would be appreciated.

question
  • 4
  • 874
  • 0
Answer
Tech Greek
Tech Greek

Tech Greek

  • 2 Questions
  • 3 Answers
  • 0 Best Answers
  • 30 Points
View Profile
  • 0
Tech GreekContributor
Asked: August 23, 2021

When i am going to registered schema with ORDS it gave me the error (ORDS RESTful services. ORA-20018)

  • 0

1 error has occurred Unable to enable schema for ORDS RESTful services. ORA-20018: Schema or user name must be a simple uppercase unquoted literal

errororacle apex
  • 1
  • 207
  • 0
Answer
VARSHA
VARSHA

VARSHA

  • 16 Questions
  • 54 Answers
  • 0 Best Answers
  • 115 Points
View Profile
  • 0
VARSHAProfessional
Asked: August 23, 2021

How to restrict user from multiple logins?

  • 0

Hi everyone, I created custom user access control , in this i want to restrict each user to one session, that is once the user login if he doesn’t logout he can not login once again, One user can have a single session How do i do this? Any help would be highly appreciated…

apex-20.2
  • 5
  • 224
  • 0
Answer
Load More Questions

Sidebar

Explore

  • Ask Question
  • Write a Tutorial
  • Tools
    • Oracle Table Script Generator
    • PL/SQL Package Generator
  • Users
  • Tags
  • FAQs
  • Badges

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us