Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01008: not all variables bound

User_5OAFPFeb 21 2013 — edited Feb 21 2013
is it possible to avoid multiple values specification for one bind variable, ie. to specify only one 'X' after using clause in the example below? if so, how should it be written properly?
declare
  s varchar2(100);
begin
  s := ' select rowid from dual where dummy = :1 ' ||
       ' union all ' ||
       ' select rowid from dual where dummy = :1 ';
  execute immediate s using 'X', 'X';
end;
thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2013
Added on Feb 21 2013
6 comments
1,809 views