Search notes:

ORA-38101: Invalid column in the INSERT VALUES Clause

Create two test tables to demonstrate the error:
create table tq84_src (
   id   number(7  ) primary key,
   val  number(5,2)
);

create table tq84_dst (
   id  number(7  ) primary key,
   val number(5,2)
);
The following statement throws ORA-38101: Invalid column in the INSERT VALUES Clause: "DST"."ID":
merge into tq84_dst dst
      using (
         select
            id,
            val
         from
            tq84_src src
      ) src
      on (
         src.id = dst.id
      )
      when     matched then
               update set  dst.val = src.val
      when not matched then
               insert (id, val)
               values (id, val)   -- <<< correct here to "values(src.id, src.val)"
;
The corrected statement is
merge into tq84_dst dst
      using (
         select
            id,
            val
         from
            tq84_src src
      ) src
      on (
         src.id = dst.id
      )
      when     matched then
               update set  dst.val = src.val
      when not matched then
               insert (    id,     val)
               values (src.id, src.val)
;
Cleaning up:
drop table tq84_src;
drop table tq84_dest;

See also

Other Oracle error messages

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...', 1759446853, '216.73.216.42', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-38101_Invalid-column-in-the-INSERT-VALUES-Clause(90): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78