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