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!

getting an error-PL/SQL: ORA-38101: Invalid column in the INSERT VALUES Cla

user8731258Sep 28 2010 — edited Sep 28 2010
BEGIN
   MERGE INTO test123
      USING test12345
      ON (test123.c1 = test12345.c2 AND test123.c2 = test12345.c2)
      WHEN MATCHED THEN
         UPDATE
            SET test123.c3 = test12345.c2
      WHEN NOT MATCHED THEN
         INSERT (c1, c2, c3)
         VALUES (c1, c2, c2);
END;
error

ORA-06550: line 2, column 4:
PL/SQL: ORA-38101: Invalid column in the INSERT VALUES Clause: "TEST123"."C1"
ORA-06550: line 2, column 4:
PL/SQL: SQL Statement ignored
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2010
Added on Sep 28 2010
4 comments
1,341 views