2 Replies Latest reply: Jul 30, 2013 2:25 AM by Ora Ash RSS

    Automatic recompile of Procedure Body Perform_query failed

    607657
      I am converting Oracle 10g form to 11g and getting the error
      "Automatic recompile of Procedure Body Perform_query failed"

      here is my procedure

      Procedure perform_query is
      v_seq number;
      v_rowid varchar2(30) := :GLOBAL.generic;
      v_where varchar2(60);

      Begin
      select col1, col2,col3
      into v_col1, :parameter.col2, :parameter.col3
      from table
      where v_rowid = table.rowid

      v_where := 'table.col1='||v_col1;
      go_block ('table');
      set_block_property('table', default_where, v_where);
      execute_query;

      End;

      please help me out.
      Note: i used Forms Compiler and opend the form in oracle 11g and tried to run it then got the above mentioned error.

      thanks