FRM-40735 and ORA-06502
934520May 2 2012 — edited May 3 2012Dear Sir
I have A proble for the build new Form, problem is that FRM-40735 WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-06502.
when i tab the cursor one field to other but course title is not shown and error is manssion cause.
when-validate-item trigger code is menssion below
begin
select title
into:class.course_title
from course
where
course_id=:class.course_id and
department_id=:department.department_id;
exception
when no_data_found then
message ('Invalid Course ID.Please enter a valid Course ID.');
raise form_trigger_failure;
end;
my email address:alimohd@neduet.edu.pk
thank to solve this problem
ali
Edited by: 931517 on May 2, 2012 5:41 AM