Hi,

   I am struggling with following sql for passing rowid as bind variable. I keep getting ORA-911 error. Thanks for your help. I made it a number column and it is still giving the same error. to make sure it is not issue with rowid or char datatype. It works when I do not use bind variable. So table and column names are fine. Any help is appreciated. thanks

 

sql_statement := 'delete from '||table_name_del||'
             where  rowid = '':b_rowid'' ';
 execute immediate (sql_statement)
      using tab_rowid;

 

for number column :

 

sql_statement := 'delete from '||table_name_del||'
             where  emp_no = :b_emp_no
             and rownum = 1';
  for i in 1..500 loop
  execute immediate (sql_statement)
      using i;

  end loop;