تعريف بداله Table_from_block

عندى معلومة عن forms Built in اسمها TABLE_FROM_BLOCK احب تشاركونى فيها
1-ا وظيفتها
لكى تنسخ بيانات من datablock الى Table of record in the memory

2- Syntax
TABLE_FROM_BLOCK (BLOCK_DATA IN <V2_TABLE_1>, BLOCK_NAME IN VARCHAR2, START_REC IN PLS_INTEGER, END_REC IN PLS_INTEGER, ITEM_DATA IN FORMS4C.ITEMS_IN_BLOCK);

Here's the Parameter definitions for the Built-in


block_data The table to populate with data.(The receiving table.)

block_name Name of the block.

start_rec First record to retrieve from the block.

end_rec Last record to retrieve from the block.

This value could be ALL_RECORDS.

item_data A supplied table listing the columns to retrieve from

the block.

Example

PROCEDURE populate_plsql_table(my_table1 my_table, cnt OUT NUMBER)
IS

/* Define a PL/SQL record with two fields code and name */

  TYPE state_rec IS RECORD (code varhcar2(2), name varhcar2(30));

/* Define a PL/SQL table of the record defined above */

  TYPE my_table IS TABLE OF state_rec INDEX BY BINARY_INTEGER;
   my_table1 my_table;

/* Define a variable of type ITEMS_IN_BLOCK. ITEMS_IN_BLOCK is a
Forms-defined table */
   Item_data ITEMS_IN_BLOCK;
   Cnt NUMBER;
BEGIN Item_data(1) := 'STATE_CODE';
     item_data(2) := 'STATE_NAME';

/* The call to the Forms built-in TABLE_FROM_BLOCK retrieves the records
from the block and populates the my_table1 table of records */

     TABLE_FROM_BLOCK(my_table1, 'STATE',1, ALL_RECORDS, item_data);
    -- The SUCCESS or FAILURE of this built-in can be assessed
     -- with FORM_SUCCESS, just like any other built-in IF NOT FORM_SUCCESS THEN
        RAISE FORM_TRIGGER_FAILURE;
    END IF;
     Cnt := my_table1.COUNT;
END populate_plsql_table;