Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ** bind variable for rowid, number column

Re: ** bind variable for rowid, number column

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 31 May 2006 13:13:56 +0800
Message-ID: <5e3048620605302213k1f8db6a0x946a782a30ac9ed1@mail.gmail.com>


On 5/31/06, A Joshi <ajoshi977_at_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<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_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 31 2006 - 00:13:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US