Execute_Query

By
Font size: Decrease font Enlarge font

Execute_Query clears the current block, opens a query, and fetches a number of selected records ( items that are with base_table TRUE). If there are changes to commit, Form Builder prompts the operator to commit them before continuing EXECUTE_QUERY processing. This alert prompt can be avoided by using NO_VALIDATE parameter with EXECUTE_QUERY

Syntax

PROCEDURE EXECUTE_QUERY;
PROCEDURE EXECUTE_QUERY (keyword_one    VARCHAR2);

PROCEDURE EXECUTE_QUERY (keyword_two    VARCHAR2);

PROCEDURE EXECUTE_QUERY (keyword_one    VARCHAR2, keyword_two    VARCHAR2);

PROCEDURE EXECUTE_QUERY (keyword_one    VARCHAR2, keyword_two    VARCHAR2, locking    VARCHAR2);

Built-in Type  restricted procedure

Enter Query Mode  yes

Parameters

no parameters EXECUTE_QUERY flushes the current block, opens a query, and fetches a number of selected records.

keyword_one EXECUTE_QUERY(ALL_RECORDS) performs the same actions as EXECUTE_QUERY except that Form Builder fetches all of the selected records.

keyword_two EXECUTE_QUERY(FOR_UPDATE) performs the same actions as EXECUTE_QUERY except that Form Builder attempts to lock all of the selected records immediately.

keyword_one/ keyword_two EXECUTE_QUERY(ALL_RECORDS, FOR_UPDATE) performs the same actions as EXECUTE_QUERY except that Form Builder attempts to lock all of the selected records immediately and fetches all of the selected records.

locking    Can be set to NO_WAIT anytime that you use the FOR_UPDATE

parameter.  When you use NO_WAIT, Form Builder displays a dialog to

notify the operator if a record cannot be reserved for update immediately.

Without the NO_WAIT parameter, Form Builder keeps trying to obtain a lock without letting the operator cancel the process.

Use the NO_WAIT parameter only when running against a data source that supports this functionality.
 
EXECUTE_QUERY restrictions

Oracle Corporation recommends that you use the ALL_RECORDS and FOR_UPDATE parameters with caution. Fetching a large number of rows could cause a long delay. Locking a large number of rows at once requires many resources.

EXECUTE_QUERY examples

/*
    Built-in:  EXECUTE_QUERY
    Example:   Visit several blocks and query their contents,
    then go back to the block where original block.
*/
DECLARE
block_before VARCHAR2(80) := :System.Cursor_Block;
BEGIN

Go_Block(’Exceptions_List’);
Execute_Query; Go_Block(’User_Profile’);
Execute_Query;
Go_Block(’Tasks_Competed’);
Execute_Query;
Go_Block( block_before );

END;

Subscribe to comments feed Comments (16 posted)

avatar
ali 11/06/2018 03:42:33
nice post
avatar
best essay writing service 12/06/2018 15:39:35
Here has the important information about the computer and computer has many kinds of works. Which we can learn it and its much useful in our life for educational and official life.
avatar
sda 27/06/2018 16:23:07
asd
avatar
bungalow Desirade 02/09/2018 15:18:51
Time of social event is all in all something worth being appreciative for however no understudy can utilize it. Commonly students stay at the libraries and complete their assignments having no time for their own specific endeavors.
avatar
bungalow Desirade 03/09/2018 02:23:50
Time of social event is all in all something worth being appreciative for however no understudy can utilize it. Commonly students stay at the libraries and complete their assignments having no time for their own specific endeavors.
avatar
Foods That Cause Inflammation 05/09/2018 14:57:31
I have read your article, it is very informative and helpful for me.I admire the valuable information you offer in your articles. Thanks for posting it..
avatar
How To Start Running 05/09/2018 16:37:27
Just saying thanks will not just be sufficient, for the fantasti c lucidity in your writing. I will instantly grab your rss feed to stay informed of any updates.
avatar
Perilla Seed Oil 05/09/2018 16:57:46
If your looking for Online Illinois license plate sticker renewals then you have need to come to the right place.We offer the fastest Illinois license plate sticker renewals in the state.
avatar
Omega-6 Fatty Acid 05/09/2018 17:17:38
I need to to thank you for this very good read!! I definitely loved every little bit of it. I have you bookmarked to check out new things you post…
avatar
Healthy Hair 05/09/2018 17:37:03
Really impressive post. I read it whole and going to share it with my social circules. I enjoyed your article and planning to rewrite it on my own blog.
1 2 next total: 16 | displaying: 1 - 10

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

Captcha
  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article

0