Dear all,
my question is ,
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.
- is EXECUTE_QUERY is not working properly in 12C form??
- or DEFAULT_WHERE issue??
Vinish
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.
IDB_SL
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.
IDB_SL
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...