Search notes:

ORA-01008: not all variables bound

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;
/
In SQL*Plus, this error can also be forced like so
SQL> set define off
SQL> var res varchar2
SQL> exec execute immediate 'select dummy from dual where 1 = &num' into :res;

See also

Other error messages such as

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758198827, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-01008_not-all-variables-bound(62): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78