Home » Developer & Programmer » Forms » Error Messages
Error Messages [message #205800] Mon, 27 November 2006 11:33 Go to next message
shellshell
Messages: 3
Registered: November 2006
Location: virginia
Junior Member

i get this message when i run my form and click the submit button

this is the coding that that i have for the sumbit button:

DECLARE
c_sec_id number(5);

BEGIN
SELECT course_sec.course_sec_id
into c_sec_id
FROM course_sec, course, term, grades
WHERE course_sec.course_sec_id = grades.course_sec_id
and course.course_id = course_sec.course_id
and course_sec.term_id = term.term_id
and term_desc = 'SPRING 2006'
and course_sec.course_sec_id = :GRADES.course_sec_id;

INSERT INTO GRADES (s_id, course_sec_id, grade)
VALUES (:GRADES.s_id, c_sec_id, :GRADES.grade);
END;

this is the error message i get

FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ora-01403

please help me somebody!!!

Re: Error Messages [message #205823 is a reply to message #205800] Mon, 27 November 2006 16:15 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SELECT statement returned the NO-DATA-FOUND error. Handle it in an EXCEPTION handler section, such as
DECLARE
   c_sec_id   NUMBER (5);
BEGIN
   SELECT course_sec.course_sec_id
     INTO c_sec_id
     FROM course_sec, course, term, grades
    WHERE course_sec.course_sec_id = grades.course_sec_id
      AND course.course_id = course_sec.course_id
      AND course_sec.term_id = term.term_id
      AND term_desc = 'SPRING 2006'
      AND course_sec.course_sec_id = :grades.course_sec_id;

   INSERT INTO grades
               (s_id, course_sec_id, grade
               )
        VALUES (:grades.s_id, c_sec_id, :grades.grade
               );
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      NULL;
END;
Re: Error Messages [message #207238 is a reply to message #205823] Mon, 04 December 2006 16:53 Go to previous messageGo to next message
shellshell
Messages: 3
Registered: November 2006
Location: virginia
Junior Member

i tried this and it gave me a error saying "FRM-40508: ORACLE error: unable to insert record".
Re: Error Messages [message #207250 is a reply to message #207238] Mon, 04 December 2006 19:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do the datatypes of the fields in the table match the datatypes of the items in the block?

David
Previous Topic: Help :Unable to update or refresh a field in master block when deleting detail record (merged)
Next Topic: Forms 9.0i Problem
Goto Forum:
  


Current Time: Sat Dec 10 19:00:16 CST 2016

Total time taken to generate the page: 0.08494 seconds