This discussion is archived
2 Replies Latest reply: Jul 30, 2013 12:25 AM by OraAsh RSS

Automatic recompile of Procedure Body Perform_query failed

607657 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points