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
IDB_SL
IDB_SL

IDB_SL

  • 1 Question
  • 2 Answers
  • 0 Best Answers
  • 25 Points
View Profile
  • 0
IDB_SLContributor
Asked: January 11, 20222022-01-11T20:48:19+05:30 2022-01-11T20:48:19+05:30

ORACLE FORMS 12C ISSUE WHEN DATABLOCK REFRESHING..

  • 0
Advertisement

Dear all,

 

my question is ,

Advertisement

i tried to refresh the data block using default where clause and then run execute_query. then the data vanished from the datablock. i can't imagine what has happen here ?

 

WKString := 'X_BLOCK.SEQ_NO = '||''''||WKOldPolSeq||'''';
GO_BLOCK('X_BLOCK');
SET_BLOCK_PROPERTY('X_BLOCK',Default_Where,WKString);
EXECUTE_QUERY();  -- when this stage data got vanished.

Advertisement
  • is EXECUTE_QUERY is not working properly in 12C form??
  • or DEFAULT_WHERE issue??

 

 

 

Advertisement

question
  • 3
  • 128
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer
    Advertisement

    3 Answers

    1. Vinish

      Vinish

      • 1 Question
      • 863 Answers
      • 74 Best Answers
      • 4k Points
      View Profile
      Vinish Enlightened
      2022-01-12T08:06:07+05:30Added an answer on January 12, 2022 at 8:06 am

      Your where clause has issues. In the where clause, you need to put table alias or nothing just column name. For example, in your case, remove the x_block from where clause, use just column seq_no.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    2. IDB_SL

      IDB_SL

      • 1 Question
      • 2 Answers
      • 0 Best Answers
      • 25 Points
      View Profile
      IDB_SL Contributor
      2022-01-12T13:10:31+05:30Added an answer on January 12, 2022 at 1:10 pm

      Dear Vinish,

      thanks for the response. but the issue is same as the previous. i think ,when i use execute_query() function and then data reading .after reading data and  those data gonna vanish. datablock cleared and show the error as 'ORA-01403: NO DATA FOUND...'

      WKOldPolSeq := :X_BLOCK.SEQ_NO;
      WKString := 'X_BLOCK.SEQ_NO = '||''''||WKOldPolSeq||''''; --idb
      SET_BLOCK_PROPERTY('SEQ_NO ',Default_Where,WKOldPolSeq);
      EXECUTE_QUERY();

      i think this execute_query function not working properly.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
    3. Advertisement
    4. IDB_SL

      IDB_SL

      • 1 Question
      • 2 Answers
      • 0 Best Answers
      • 25 Points
      View Profile
      IDB_SL Contributor
      2022-01-12T13:27:04+05:30Added an answer on January 12, 2022 at 1:27 pm

      Dear Vinish,

      i wan to do in ,when i run the 12c form and that form had an update statement of the table[x_block is a table name] and again i wan to refresh this table and get current data to the data block. that's why i use this execute_query to get the value. this is done in same form.

      plz help...

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter

    You must login to add an answer.

    Forgot Password?

    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