** bind variable for rowid, number column
- From: A Joshi <ajoshi977@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 30 May 2006 10:53:19 -0700 (PDT)
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:
