Re: ** bind variable for rowid, number column
On 5/31/06, A Joshi <firstname.lastname@example.org> wrote:
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
Love cheap thrills? Enjoy PC-to-Phone
calls to 30+ countries for just 2¢/min with Yahoo! Messenger with Voice.
2 x varchar2(1);
3 r rowid;
5 select rowid into r from dual;
7 execute immediate
8 'select * from dual where rowid = :b1' into x using r;
PL/SQL procedure successfully completed.
"Semper in excremento, sole profundum qui variat"