Home » Developer & Programmer » Forms » FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 (Oracle forms and report 10G)
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #560797] Tue, 17 July 2012 03:56 Go to next message
annuar85
Messages: 7
Registered: July 2012
Location: Malaysia
Junior Member
Hello All,

When i pressed button in my form i get this error:

FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913..

My codding as per attached.

Im just wanna to know,isit the problem come from my button pressed or data..

Please help me solved this problem since i'm new in oracle..
  • Attachment: Code.txt
    (Size: 29.30KB, Downloaded 228 times)
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 messageGo to next message
Littlefoot
Messages: 18824
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:Oracle
ORA-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.
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #560932 is a reply to message #560819] Tue, 17 July 2012 19:46 Go to previous messageGo to next message
annuar85
Messages: 7
Registered: July 2012
Location: Malaysia
Junior Member
Sir sorry since im new in oracle area..thanks for the information,anyway how about this statement isit possible cause the return ora-00913...


cursor course_assg(old_intake varchar2, ssem varchar2,ddegree varchar2) is select * from course_seq
where intake = old_intake
and semester_id = ssem
and degree = ddegree
order by intake, course_level, seq asc ;


Sorry for my bad English..
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #560953 is a reply to message #560932] Wed, 18 July 2012 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 18824
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I wouldn't say so as you never use that cursor (you declare it, but don't fetch from it).
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #561027 is a reply to message #560953] Wed, 18 July 2012 06:27 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Even if you did fetch it couldn't be the culprit. Explicit cursors can never raise that error, only implicit cursors (SELECT ... INTO ...) can.
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #561028 is a reply to message #561027] Wed, 18 July 2012 06:28 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use messages to determine which exact bit of code is reached when the error occurs.
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #585055 is a reply to message #560797] Tue, 21 May 2013 10:13 Go to previous messageGo to next message
mohdmansoor2006
Messages: 2
Registered: June 2010
Location: saudia, jeddah
Junior Member

send me some more coding
Re: FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-00913 [message #585061 is a reply to message #585055] Tue, 21 May 2013 11:17 Go to previous message
Littlefoot
Messages: 18824
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you mean by saying that? What "more coding"? How is your message related to this discussion?
Previous Topic: Need Help on Oracle Forms to MS-Excel
Next Topic: set_lov_property with respect to list item
Goto Forum:
  


Current Time: Fri Apr 18 00:38:31 CDT 2014

Total time taken to generate the page: 0.14302 seconds