Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

key-next-item

vikas singhalSep 29 2010 — edited Sep 29 2010
Hi all

i have two triggers on a item

first is when-validate-trigger
BEGIN
	SELECT prod_code,prod_name,prod_color,xs,s,m,l,xl,pcs 
	INTO 	:gin_detail1.prod_id1,:gin_detail1.prod_name,:gin_detail1.color,
	:gin_detail1.xs,:gin_detail1.s,:gin_detail1.m,:gin_detail1.l,:gin_detail1.xl,:gin_detail1.pcs 
	FROM product_barcode
	where barcode = :gin_detail1.prod_id;
	next_record;
end;
and the seocnd is key-next-item
DECLARE
	A number;
	B number;
	C number;
	D number;
	E number;
	F number;
	--CURSOR C1 IS 
BEGIN
		SELECT XS,S,M,L,XL,PCS INTO A,B,C,D,E,F from SALE_ORDER_ACCOUnt 
	where PROD_iD=:gin_detail1.prod_id
	and color=:gin_detail1.color ;
	IF :GIN_DETAIL1.s > b THEN
	MESSAGE('pLEASE CHECK THE STOCK');
	MESSAGE('pLEASE CHECK THE STOCK');
	go_item('gin_detail1.prod_id');
	ELSE
		update sale_order_account
		set s = s-1 where PROD_iD=:gin_detail1.prod_id
	and color=:gin_detail1.color ;
				next_record;
		END IF;
		next_record;
END;
when i run the form and press the on that item where i put my code the error comes
* FRM-40735 KEY-next-item trigger raised unhandeled exception ORA-01403*

Please Guide
Thanks And Regards
Vikas Singhal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 27 2010
Added on Sep 29 2010
10 comments
1,701 views