-
forms troubles
hi,
I've next problem:
In a compilled form module when i press the button (which it should to return to me the result of my interogation) i'm obtaining next error message:
frm-40735ra-04122:exact fetch returns more then requested number of rows.
How do i treat this error in my internal code?
the data stored in the interogation table excludes any duplicates.
Thanks a lot!
sorry for my english!
-
U can use Following Code In Form level (ON-Error)Trigger
BEGIN
/*Put Error Message umber here*/
IF ERROR_CODE = '40815' THEN
NULL;
ELSE
MESSAGE (ERROR_CODE || ' ' || ERROR_TEXT);
MESSAGE (' ');
CLEAR_MESSAGE;
END IF;
END;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|