Oracle Forms

Hi

oracle and forms 10G

the code on key down is

DECLARE
	p_color BOOLEAN;
BEGIN
	p_color := SHOW_LOV('color');
	insert into product_code
	(prod_code,
	prod_name,
	prod_color,prod_id)
values (:PRODUCT.prod_id,
:prod_name,
:AVAILABLE_COLORS,
:product.prod_id);
next_record;
END;


Table where data to inserted is

SQL> desc product_code;
 Name                                      Null?    Type
 ----------------------------------------- -------- --------------
 PROD_CODE                                          VARCHAR2(100)
 PROD_NAME                                          VARCHAR2(150)
 PROD_COLOR                                         VARCHAR2(50)
 PROD_ID                                            VARCHAR2(50)
 XS                                                 NUMBER
 S                                                  NUMBER
 M                                                  NUMBER
 L                                                  NUMBER
 XL                                                 NUMBER
 PCS                                                NUMBER

Please Guide

Thanks And Regards
Vikas Singhal