** bind variable for rowid, number column

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Tue, 30 May 2006 10:53:19 -0700 (PDT)
Message-ID: <20060530175319.36236.qmail@web60716.mail.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Tue May 30 2006 - 12:53:19 CDT