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:
sql_string:= '(select empno,ename from EMP where empno ='||:BL.T||')';
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.