|
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #560819 is a reply to message #560797] |
Tue, 17 July 2012 05:08 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Whoa! You must be kidding! Do you really expect me to debug over 1000 lines of code and search for ORA-00913 error? Someone much nicer than me might do that, though, but I won't.
Anyway:OracleORA-00913: too many values
Cause: The SQL statement requires two sets of values equal in number. This error occurs when the second set contains more items than the first set. For example, the subquery in a WHERE or HAVING clause may return too many columns, or a VALUES or SELECT clause may return more columns than are listed in the INSERT.
Action: Check the number of items in each set and change the SQL statement to make them equal.
An example:SQL> select e.ename, e.job, e.sal
2 from emp e
3 where e.deptno in (select d.deptno, d.dname
4 from dept d
5 );
where e.deptno in (select d.deptno, d.dname
*
ERROR at line 3:
ORA-00913: too many values
SQL>
See line #3: WHERE DEPTNO in (DEPTNO, DNAME).
Left: one column (DEPTNO).
Right: two columns (DEPTNO, DNAME)
Something like that must have happened in your code as well. Have a look.
|
|
|
|
|
|
|
|
|