Re: ** bind variable for rowid, number column

On 5/31/06, A Joshi <ajoshi977@yahoo.com> wrote:

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

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

SQL> declare
2    x varchar2(1);
3    r rowid;
4 begin
5    select rowid into r from dual;
6
7    execute immediate
8      'select * from dual where rowid = :b1' into x using r;
9
10 end;
11 /

PL/SQL procedure successfully completed.

--
Connor McDonald
===========================
email: connor_mcdonald@yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

Re: ** bind variable for rowid, number column

Connor McDonald

2006-05-31