The following SQL statement is parametrized with two bind variables, but only one bind variable is bound. Hence, Oracle throws ORA-01008: not all variables bound.
declare
cnt number;
begin
execute immediate
'select
count(*)
from
dual
where
1 = :a and
2 = :b'
into cnt
using 1;
end;
/