Hello experts,
I am using oracle forms 11g with weblogic 10.3.5 at windows 7.I have a datablock say emp and it has 2 items as:
empno & ename.
Now I am trying to change emp data block query data sorce name property at a button press in BL data block:
declare
sql_string varchar2(2000);
begin
message('before start');
--pause;
sql_string:= '(select empno,ename from EMP where empno ='||:BL.T||')';
set_block_property('EV',QUERY_DATA_SOURCE_NAME,sql_string);
go_block('EV');
clear_block;
execute_query;
--pause;
end;
Here I got data inside EMP successfully but if another time I press the button than there the form goes in search(disable) mode an I did not get data inside emp data block again.
.Actually I need to make a datablock which would have data from a sql query based on a where clause condition in oracle forms.Please tell me what is going wrong here.
Thank You
regards
aaditya