Re: ** bind variable for rowid, number column

On 5/31/06, A Joshi <ajoshi977@xxxxxxxxx> 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<http://us.rd.yahoo.com/mail_us/taglines/postman9/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com/>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@xxxxxxxxx
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

Other related posts: