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
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: October 6, 2020

    Where to handle errors in process or store procedure ?

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Replied to answer on March 19, 2022 at 7:35 am

    From the PL/SQL dynamic action set the returned error message value to a hidden page item using the apex_util.set_session_state method. And write a dynamic action on that hidden item for change event and show the error message using the JavaScript alert.

    From the PL/SQL dynamic action set the returned error message value to a hidden page item using the apex_util.set_session_state method. And write a dynamic action on that hidden item for change event and show the error message using the JavaScript alert.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: September 18, 2021

    how to add date facet in faceted search

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 18, 2021 at 2:04 pm

    You need to get the date column as varchar2 and use the input field instead. For example: select ORDER_ID, CUSTOMER_ID, ORDER_TOTAL, to_char(trunc(ORDER_TIMESTAMP), 'mm-dd-yyyy') od, USER_NAME, TAGS from DEMO_ORDERS Now for the OD column, use the input field and for the database column property, speRead more

    You need to get the date column as varchar2 and use the input field instead. For example:

    select ORDER_ID,
    CUSTOMER_ID,
    ORDER_TOTAL,
    to_char(trunc(ORDER_TIMESTAMP), 'mm-dd-yyyy') od,
    USER_NAME,
    TAGS
    from DEMO_ORDERS

    Now for the OD column, use the input field and for the database column property, specify the OD column. Then you would be able to enter a date using the same format specified in the SQL query to filter the result at runtime.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: September 16, 2021

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

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 16, 2021 at 12:57 pm

    You can use apex_mail in the database procedure as you use in Oracle Apex, but instead, use UTL_SMTP to send mail outside of Apex is better.

    You can use apex_mail in the database procedure as you use in Oracle Apex, but instead, use UTL_SMTP to send mail outside of Apex is better.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: September 15, 2021

    How to call ajax callback process in modal dialog page?

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 15, 2021 at 4:25 pm

    On your dialog page, create a region as URL type, and in the attributes section, specify the Ajax application URL. Then it should load.

    On your dialog page, create a region as URL type, and in the attributes section, specify the Ajax application URL. Then it should load.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: September 11, 2021

    How to save and remember user on login page ?

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 12, 2021 at 10:28 am

    In Oracle Apex, there is an item P9999_REMEMBER created by default on the login page. And has a process code as below: apex_authentication.send_login_username_cookie ( p_username => lower(:P9999_USERNAME), p_consent => :P9999_REMEMBER = 'Y' ); So if your page is not having this item, you can cRead more

    In Oracle Apex, there is an item P9999_REMEMBER created by default on the login page. And has a process code as below:

    apex_authentication.send_login_username_cookie (
    p_username => lower(:P9999_USERNAME),
    p_consent => :P9999_REMEMBER = 'Y' );

    So if your page is not having this item, you can create an item P9999_REMEMBER and then create a process and add the above code. It will then function as required.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: September 8, 2021

    How to get confirmation message for Logout

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 10, 2021 at 3:46 pm

    Create a modal dialog page to confirm the logout action. And if the user select Ok then execute the following PL/SQL code: apex_authentication.logout(:SESSION, :APP_ID); Now, go to Shared Components > Navigation List and edit the Sign Out list entry. Change the Target type to Page in this ApplicaRead more

    Create a modal dialog page to confirm the logout action. And if the user select Ok then execute the following PL/SQL code:

    apex_authentication.logout(:SESSION, :APP_ID);

    Now, go to Shared Components > Navigation List and edit the Sign Out list entry.

    Change the Target type to Page in this Application and specify the dialog page you created.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: August 27, 2021

    Generate from Interactive Report and Insert into DB Table

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 7, 2021 at 5:33 pm

    You can test for the BLOB by storing it in a temporary table and then check the BLOB data from that table. Then you will come to know if your BLOB is ok. And if the BLOB is ok, then the issue is with your email program.

    You can test for the BLOB by storing it in a temporary table and then check the BLOB data from that table. Then you will come to know if your BLOB is ok.

    And if the BLOB is ok, then the issue is with your email program.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: September 7, 2021

    how can i send report direct on printer ?

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 7, 2021 at 3:30 pm

    Use the Google cloud printing option. After this, you just need to send the BLOB or CLOB to a mail id configured with the Google cloud printing service.

    Use the Google cloud printing option. After this, you just need to send the BLOB or CLOB to a mail id configured with the Google cloud printing service.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: September 2, 2021

    Java call terminated by uncaught Java exception:

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 3, 2021 at 7:33 am

    You need to give permissions using dbms_java.grant_permission() method. Below is an example: Login as SYS or System, then execute the following PL/SQL block by making the changes according to your schema and hostname: Begin dbms_java.grant_permission('YourSchema', 'java.net.SocketPermission', 'yourHRead more

    You need to give permissions using dbms_java.grant_permission() method. Below is an example:

    Login as SYS or System, then execute the following PL/SQL block by making the changes according to your schema and hostname:

    Begin
    dbms_java.grant_permission('YourSchema',
    'java.net.SocketPermission',
    'yourHostname',
    'resolve');
    commit;
    
    dbms_java.grant_permission('YourSchema',
    'java.util.PropertyPermission',
    '*',
    'read,write');
    commit;
    End;
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: September 2, 2021

    How to escape "&" in checksum of URL?

    Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    Added an answer on September 2, 2021 at 2:32 pm

    Set the following setting for page no. 1: Open your page then go to Settings > Security > Page Access Protection to Unrestricted.

    Set the following setting for page no. 1:

    Open your page then go to Settings > Security > Page Access Protection to Unrestricted.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 … 73

Sidebar

Explore

  • Ask Question
  • Add Post

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