Hi Team ,
I am using Forms 11G.
I have a block which is based on a complex view .
Also I have a package which I am calling in the Advance Databse property of the block . In this package I have declare a TYPE as below .
Create or replace package .......
.......
TYPE TariffnoDetail IS RECORD(item_no VARCHAR2(15),
ga_code_imp VARCHAR2(10),
tar_no1 VARCHAR2(6),
valid_date_from DATE,
export_key VARCHAR2(3),
pre_class VARCHAR2(18),
user_code_upd VARCHAR2(10),
upd_date DATE,
change_flag VARCHAR2(1),
item_type VARCHAR2(3),
tar_no2 VARCHAR2(12),
bind_tar_info VARCHAR2(100),
item_desc_cust VARCHAR2(100),
reason_code VARCHAR2(50),
tar_status VARCHAR2(20),
cais_proc VARCHAR2(100)
);
TYPE TariffnoDetail_ref IS
REF CURSOR
RETURN TariffnoDetail;
TYPE TariffnoDetail_tab IS
TABLE OF TariffnoDetail
INDEX BY BINARY_INTEGER;
These columns also I have updated in the INSERT PROCEDURE RESULT SET OF COLUMNS property of the block and for Insert procedure arguments propery i have set DMLSET nd type name is to TARIFFNODETAILP.TARIFFNODETAIL_TAB (the aboove package ).
After this I can see there are 3 procedure created autometically :
UPDATE-PROCEDURE
DECLARE
bk_data TARIFFNODETAILP.TARIFFNODETAIL_TAB;
BEGIN
PLSQL_TABLE.POPULATE_TABLE(bk_data, 'ITEM_CTY_TAR_CURRENT', PLSQL_TABLE.UPDATE_RECORDS);
CALL_TARIFFNO_PRETARIFFNO.p_tariffno(bk_data);
END;
INSERT-PROCEDURE
DECLARE
bk_data TARIFFNODETAILP.TARIFFNODETAIL_TAB;
BEGIN
PLSQL_TABLE.POPULATE_TABLE(bk_data, 'ITEM_CTY_TAR_CURRENT', PLSQL_TABLE.INSERT_RECORDS);
CALL_TARIFFNO_PRETARIFFNO.p_tariffno(bk_data);
END;
LOCK-PROCEDURE
DECLARE
bk_data TARIFFNODETAILP.TARIFFNODETAIL_TAB;
BEGIN
PLSQL_TABLE.POPULATE_TABLE(bk_data, 'ITEM_CTY_TAR_CURRENT', PLSQL_TABLE.LOCK_RECORDS);
CALL_TARIFFNO_PRETARIFFNO.p_tariffno_lock(bk_data);
END;
Please find the screen shot below of the block property for Database and Advance database .
After all these things when I am trying to update or save something then it is showing this error :
PL/SQL built-in PLSQL_TABLE.POPULATE_TABEL failed.