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