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

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: August 5, 2021

    pop lov based on Page Item Values

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on August 6, 2021 at 8:34 pm

    Dear vinish, waiting for your comments and guidance.  

    Dear vinish,

    waiting for your comments and guidance.

     

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

    Insert Image into BLOB manually

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Replied to answer on July 22, 2021 at 4:05 pm

    Dear Ashish Sahay , can you please point out where is the problem in codes. Following Javascript to call ajax callback process. apex.server.process("bank_payment_mst", {     pageItems: "#P17_DATE,#P17_PROOF1",     x01: $v(P17_DATE),     x02: $v(P17_PROOF1) },     {         success: function (pData) Read more

    Dear Ashish Sahay ,

    can you please point out where is the problem in codes.

    Following Javascript to call ajax callback process.

    apex.server.process("bank_payment_mst", {
        pageItems: "#P17_DATE,#P17_PROOF1",
        x01: $v(P17_DATE),
        x02: $v(P17_PROOF1)

    },
        {
            success: function (pData) {
                // Codes in Case of Success
                apex.item('P17_VNUMBER').setValue(pData.vno);

            },
            error: function( jqXHR, textStatus, errorThrown ) {
                // Codes in Case of Error

        }
    });
    following is ajax callback process.

    declare
        mid int;
       l_proof1 blob;
    begin
        select nvl(max(mid),0)+1 into mid from voucher_mst;
        SELECT blob_content
            INTO l_proof1
            FROM apex_application_temp_files
            WHERE NAME = apex_application.g_x02;
        insert into voucher_mst values(mid,apex_application.g_x01,apex_application.g_x02);

       apex_json.open_object;
            apex_json.write('mid', mid);
       apex_json.close_all;
    exception when no_data_found then
        raise_application_error(-20111,'problem saving ');
    end;
    following is error in console.

    Error: Ajax call returned server error ORA-01403: no data found for 
    .
    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Advertisement
  4. Asked: July 15, 2021

    Insert Image into BLOB manually

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on July 19, 2021 at 1:10 pm

    Dear Vinish, please guide me about above mention code to complete my form.  

    Dear Vinish,

    please guide me about above mention code to complete my form.

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: July 17, 2021

    HOW TO FIX COLUMN OF INTERACTIVE GRID

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on July 17, 2021 at 3:47 pm

    Freezing column may fix the problem  

    Freezing column may fix the problem

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Advertisement
  7. Asked: July 15, 2021

    Insert Image into BLOB manually

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on July 17, 2021 at 1:05 pm

    can you please tell me what is wrong in following code. declare     mid int;     l_blob blob; begin     select nvl(max(mid),0)+1 into mid from voucher_mst;     SELECT blob_content         INTO l_blob         FROM apex_application_temp_files         WHERE NAME = :P15_PROOF1;     insert into voucher_mRead more

    can you please tell me what is wrong in following code.

    declare
        mid int;
        l_blob blob;
    begin
        select nvl(max(mid),0)+1 into mid from voucher_mst;
        SELECT blob_content
            INTO l_blob
            FROM apex_application_temp_files
            WHERE NAME = :P15_PROOF1;
        insert into voucher_mst values(mid,l_blob );

       apex_json.open_object;
            apex_json.write('mid', mid);
        apex_json.close_all;

    exception when no_data_found then
        raise_application_error(-20111,'Some thing Went wrong');
    end;

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: July 15, 2021

    Insert Image into BLOB manually

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on July 16, 2021 at 3:28 pm

    Dear Vinish, waiting for your early response.  

    Dear Vinish,

    waiting for your early response.

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Advertisement
  10. Asked: July 15, 2021

    How to submit the item value and refrer in another item without submitting the page

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on July 15, 2021 at 1:01 pm

    you need DA and set value of page item you want to be updated. create dynamic action when you need to update page item. Type should be Set Value. setting => Set type = Java Expression in javascript expression write following accounting to your page item to be copied $v('your_page_item'); AffectedRead more

    you need DA and set value of page item you want to be updated.

    create dynamic action when you need to update page item. Type should be Set Value.

    setting => Set type = Java Expression

    in javascript expression write following accounting to your page item to be copied

    $v('your_page_item');

    Affected Item => Selection Type => Item(s)

    Item(s) = select page item

    that's all

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  11. Asked: July 13, 2021

    Stop Success Message On Page Refresh

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on July 14, 2021 at 11:56 am

    following code shall remove any success or error message on page. apex.message.clearErrors(); apex.message.hidePageSuccess();  

    following code shall remove any success or error message on page.

    apex.message.clearErrors();
    apex.message.hidePageSuccess();

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  12. Advertisement
  13. Asked: December 20, 2020

    How to call database procedure on button click

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Added an answer on June 29, 2021 at 7:35 pm

    create dynamic action on button click. Action = Server side code Language = PL/SQL in pl/sql code write as bellow begin your_procedure_name(list of parameters here); end; that's all. if things are ok it shall do the job    

    create dynamic action on button click.

    Action = Server side code

    Language = PL/SQL

    in pl/sql code write as bellow

    begin

    your_procedure_name(list of parameters here);

    end;

    that's all. if things are ok it shall do the job

     

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  14. Asked: June 14, 2021

    saving image in table vs application directory in oracle apex

    Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 10 Questions
    • 20 Answers
    • 0 Best Answers
    • 99 Points
    View Profile
    Abdul Aqeel Malik Professional
    Replied to answer on June 14, 2021 at 4:16 pm

    thanks. this procedure is to convert blob in table to file. In my case if I get file with file browser and when user press save button I want to change file name to voucher number just saved and save file on disk. I think for this purpose we don't need to save file into blob table and than convert tRead more

    thanks. this procedure is to convert blob in table to file.
    In my case if I get file with file browser and when user press save button I want to change file name to voucher number just saved and save file on disk. I think for this purpose we don't need to save file into blob table and than convert to file. please guide me if I am wrong.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
1 2
Advertisement

Sidebar

Ask Question
Write a Tutorial
Advertisement

Recent Blog Posts

  • Vinish

    Oracle LENGTH()

  • Vinish

    Oracle INSTR() Function

  • Vinish

    Oracle INITCAP() Function

  • Vinish

    Oracle Concat

  • Vinish

    Oracle CHR Function

Advertisement
Advertisement

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