** bind variable for rowid, number column

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;
 

                
---------------------------------
Love cheap thrills? Enjoy PC-to-Phone  calls to 30+ countries for just 2¢/min 
with Yahoo! Messenger with Voice.

Other related posts: