0 Replies Latest reply on Dec 25, 2013 9:25 AM by 979801

    Problem with Query Data Source Name datablock property in Orcale forms

    979801

      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