PLS-00396: INSERT statement's subquery yields wrong number
Answer / guest
Cause: The number of columns in an INSERT statement does not
match the number of columns in a subquery select list. For
example, the following statement is faulty because no
corresponding column is specified for col3: INSERT INTO emp
(ename, empno) SELECT col1, col2, col3 FROM ...
Action: Change the number of items in the column list of the
INSERT statement or the number of items in the select list
so that the numbers match.
Please add more information about this Error
|Is This Answer Correct ?||0 Yes||2 No|
ORA-24093: AQ agent string not granted privileges of database user string
LSX-00126: facet "~1S" has invalid value "~u"
ORA-12028: materialized view type is not supported by master site string
ORA-09712: orasrv: log archiver already connected.
ORA-08208: ora_addr: cannot read from address file
ORA-31112: fail to string for string port using xdb configuration
ORA-25258: cannot register for notifications on an 8.0 style exception queue
LPX-00207: expected "[" at the start of conditional section
ORA-18004: outline already exists
ORA-38461: XML Tag "string" already exists for the XMLType attribute "string"
ORA-09793: szguns: length of user name is greater than buffer.
LPX-00264: send failed to host ~s