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
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: August 18, 2020

    How to update column when dialog is closed?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Replied to answer on December 30, 2021 at 5:51 pm

    Hi! Sorry for my late answer. Create function on parent page: function customEvent(event, data){ apex.event.trigger(document, event, data); } Then on the Modal page in dialog section add: close: function() { customEvent('customDialogClose', {modalPageId: 'MODAL_CLOSE_FIXED'});} Add dynamic action: ERead more

    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: September 2, 2021

    How to escape "&" in checksum of URL?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Added an answer on September 2, 2021 at 3:28 pm

    Solution: APEX_ESCAPE.HTML(APEX_UTIL.PREPARE_URL ( p_url => 'f?p=' || :APP_ID || ':1:'|| :APP_SESSION ||'::NO::P1_ID:'|| x.ID ||'', p_checksum_type => 'PUBLIC_BOOKMARK'))

    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: September 2, 2021

    How to escape "&" in checksum of URL?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Added an answer on September 2, 2021 at 3:11 pm
    This answer was edited.

    I found a note from Oracle: https://docs.oracle.com/en/database/oracle/application-express/20.2/aeapi/PREPARE_URL-Function.html#GUID-A61DFF37-2211-43E4-B7FE-B89C31E151FF

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: September 2, 2021

    How to escape "&" in checksum of URL?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Replied to answer on September 2, 2021 at 2:54 pm

    Also I need to incloude that URL in export, file as PUBLIC_BOOKMARK

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: September 2, 2021

    How to escape "&" in checksum of URL?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Replied to answer on September 2, 2021 at 2:44 pm

    is that a secure way?

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: August 7, 2021

    How to redirect page with DA using PL/SQL?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Replied to answer on August 10, 2021 at 2:17 pm

    Thanks, but when I use this code in DA - PL/SQL Execute Server-side Code, it doesn't work.

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: August 2, 2021

    How to use data dynamically in Oracle JET timeline?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Replied to answer on August 4, 2021 at 1:23 pm

    Thank you Vinish! I solved problem with JSON.parse($v("PXX_JSON"));

    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: August 2, 2021

    How to use data dynamically in Oracle JET timeline?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Replied to answer on August 4, 2021 at 12:28 pm
    This answer was edited.

    I tried, when I use code from page item (item has computation before header) it works. but, when I reference item: self.seriesData = $v("PXX_JSON"); I got "No data to display".

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: June 26, 2021

    How to change background color dynamically in cards region?

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Added an answer on June 28, 2021 at 2:51 am
    This answer was edited.

    Thanks a lot! Works perfectly!

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: June 26, 2021

    Using Localtimestamp in Oracle APEX

    pavlos

    pavlos

    • 37 Questions
    • 107 Answers
    • 1 Best Answer
    • 376 Points
    View Profile
    pavlos Guru
    Added an answer on June 26, 2021 at 2:04 pm
    This answer was edited.

    Hi! Did you check your time zone settings? Go to app > Edit application attributes > Globalization and set Automatic Time Zone to on. From Oracle Apex help: "Controls the setting of the database session time zone. When set to On, the client time zone is derived from the client's Web browser anRead more

    • 2
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 11

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