Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you 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

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Ask Question
  • Write a Tutorial
  • Online Courses
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier
  • Ask Question
  • Write a Tutorial
  • Online Courses
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: July 6, 2021

    Redirect Page by function call in before-header process

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on July 21, 2021 at 5:42 pm

    I am not quite sure whether this is what fits the best here since my url depends on the state which I retrieve from the table. But in the post, the target page is already set manually...

    I am not quite sure whether this is what fits the best here since my url depends on the state which I retrieve from the table. But in the post, the target page is already set manually...

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: July 6, 2021

    Redirect Page by function call in before-header process

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Replied to answer on July 21, 2021 at 5:38 pm

    Yes this is what I want, regarding the state from the table I want to redirect to another page in the same application.  

    Yes this is what I want, regarding the state from the table I want to redirect to another page in the same application.

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: May 26, 2021

    Getting error ORA-00904 when creating interactive report

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on June 1, 2021 at 12:00 pm

    Hello yes I have also seen that but in the query I use f.SPID

    Hello yes I have also seen that but in the query I use f.SPID

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: May 26, 2021

    Getting error ORA-00904 when creating interactive report

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on May 31, 2021 at 11:49 am

    Sure, I can explain it. This is the SQL query on which the interactive report is based: select f.FPID, f.TITLE,f.DATE,f.STATE FROM FORM f left outer join MANAGER m on m.MID=f.MID left outer join USERS u on u.UUID=m.UUID where lower(u.username)=lower(:session_user_name); With this query, the report iRead more

    Sure, I can explain it.

    This is the SQL query on which the interactive report is based:

    select f.FPID, f.TITLE,f.DATE,f.STATE 
    FROM FORM f
    left outer join MANAGER m on m.MID=f.MID
    left outer join USERS u on u.UUID=m.UUID
    where lower(u.username)=lower(:session_user_name);

    With this query, the report is displayed normally.
    However, when I try to retrieve another column from the Form table for the report, I get the error described above.

    select f.FPID, f.TITLE,f.DATE,f.STATE, f.SPID
    FROM FORM f
    left outer join MANAGER m on m.MID=f.MID
    left outer join USERS u on u.UUID=m.UUID
    where lower(u.username)=lower(:session_user_name);
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: May 17, 2021

    Create Row Button to update table and set value of page item

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on May 18, 2021 at 9:07 pm

    Hello:) thank you for this answer I will try it!:)

    Hello:) thank you for this answer I will try it!:)

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: May 17, 2021

    Create Row Button to update table and set value of page item

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on May 17, 2021 at 5:06 pm

    select (u.LASTNAME||','||u.FIRSTNAME) as Name, u.EMAIL, u.ID,m.MID 'Update' upd from users u right outer join manager on m.MID=u.MID where utl_match.jaro_winkler_similarity(:P8_LASTNAME,u.LASTNAME)>80; the sql query is actually structured like this

    select (u.LASTNAME||','||u.FIRSTNAME) as Name, u.EMAIL,
    u.ID,m.MID
    'Update' upd
    from users u
    right outer join manager on m.MID=u.MID
    where utl_match.jaro_winkler_similarity(:P8_LASTNAME,u.LASTNAME)>80;
    
    
    the sql query is actually structured like this
    
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: May 17, 2021

    Create Row Button to update table and set value of page item

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on May 17, 2021 at 4:39 pm

    Yes I am submitting the item P8_MID, sorry did  not mention it

    Yes I am submitting the item P8_MID, sorry did  not mention it

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

    How can values be passed in the URL

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on May 7, 2021 at 4:36 pm

    Hello Vinish, this is how I set the P8_ID. I created a pre-rendering process with the following PL/SQL Code: declare l_id number; begin select f.id into l_id from formtable f left outer join users u on u.UUID=f.UUID where lower(u.username)=lower(:session_user_name); apex_util.set_session_state('P8_IRead more

    Hello Vinish,

    this is how I set the P8_ID.

    I created a pre-rendering process with the following PL/SQL Code:

    declare 
    l_id number;
    begin
    
    select f.id into l_id from formtable f
    left outer join users u on u.UUID=f.UUID
    where lower(u.username)=lower(:session_user_name);
    apex_util.set_session_state('P8_ID',l_id);
    end;

    I checked it by viewing the session in the debug tool bar.

    And the value is set.

    By using this function:

    DECLARE
    l_branch_page number;
    l_id number;
    
    begin
    select id into l_finalpaper_id from formtable where id=:P8_ID;
    l_branch_page:= FORWARDING_TO_PAGE(:P8_ID);
    :P8_URL :=apex_page.get_url(p_page => l_branch_page,p_items=>l_id);
    
    END;

    I get the error:

    ERR-1002 Unable to find item ID for item "5" in application "100".

    The number 5 is the ID of the form.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: May 6, 2021

    Create column in interactive report to redirect to corresponding page

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Added an answer on May 7, 2021 at 1:12 pm

    Ok it works I just have to change the second it to: case when......(first case) when....(second case) Thank you so much for this blog post!

    Ok it works I just have to change the second it to:

    case when......(first case)

    when....(second case)

    Thank you so much for this blog post!

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: May 6, 2021

    Create column in interactive report to redirect to corresponding page

    Ana

    Ana

    • 23 Questions
    • 31 Answers
    • 0 Best Answers
    • 149 Points
    View Profile
    Ana Professional
    Replied to answer on May 7, 2021 at 12:40 pm
    This answer was edited.

    Hello Vinish thank you for your fast answer!:) The redirection takes place when I only have one case, when I insert a second one I unfortunately get the error I already described.  

    Hello Vinish thank you for your fast answer!:)

    The redirection takes place when I only have one case, when I insert a second one I unfortunately get the error I already described.

     

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2 3 4

Sidebar

Ask Question
Write a Tutorial

Recent Blog Posts

  • Vinish

    What is Oracle ERP?

  • Vinish

    The Benefits of Unit Testing

  • Vinish

    Java OOPS Concepts MCQ Quiz

  • Vinish

    What is the Best Database to Use?

  • Vinish

    Sending Query Strings in Post Requests in C#

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • Image to Base64
  • PL/SQL Beautifier

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