Am doing a HRMS module in forms 10g,i have used webutil package for keeping a browse button through which i can fetch images into my form (for example:employee_pic) and my table name in database is m_employee which contains(EMP_ID VARCHAR2(9),EMP_NAME VARCHAR2(20),DOB DATE,PRESENT_ADDRESS VARCHAR2(50),PERMANENT_ADDRESS VARCHAR2(50),COMM_ADDRESS
VARCHAR2(50),DESIGNATION VARCHAR2(15),JOIN_DATE DATE,RELEIVING_DATE DATE,DEPTCODE VARCHAR2(7),NETSAL NUMBER(8,2),MOBIL_NO NUMBER(10),
ALT_MOBIL_NO NUMBER(10),PERS_MAILID VARCHAR2(25) ,OFF_MAILID VARCHAR2(25),GENDER VARCHAR2(1),FATHER_NAME VARCHAR2(20),
MARITAL_STATUS VARCHAR2(1),EDU_QUALIFY VARCHAR2(10),BLOOD_GROUP VARCHAR2(5),PAN_NUMBER VARCHAR2(10),BANK_CODE VARCHAR2(5),
ACC_NO NUMBER(20),PASS_STATUS VARCHAR2(1),PASS_NUMBER NUMBER,PAY_MODE,EMP_PIC VARCHAR2(1))
and i have fetched these column into my forms and designed according to it, den i have placed an insert button(INSERT), so if i press insert the values should be stored into the database and the code which i used for insert is
INSERT INTO M_EMPLOYEE(EMP_ID,EMP_NAME,DOB,PRESENT_ADDRESS,PERMANENT_ADDRESS,COMM_ADDRESS,DESIGNATION,JOIN_DATE,RELEIVING_DATE,DEPTCODE,NETSAL,MOBIL_NO,
ALT_MOBIL_NO,PERS_MAILID,OFF_MAILID,GENDER,FATHER_NAME,MARITAL_STATUS,EDU_QUALIFY,BLOOD_GROUP,PAN_NUMBER,
BANK_CODE,ACC_NO,PASS_STATUS,PASS_NUMBER,PAY_MODE,EMP_PIC)
VALUES(':M_EMPLOYEE.EMP_ID',':M_EMPLOYEE.EMP_NAME',':M_EMPLOYEE.DOB',':M_EMPLOYEE.PRESENT_ADDRESS',':M_EMPLOYEE.PERMANENT_ADDRESS',
':M_EMPLOYEE.COMM_ADDRESS',':M_EMPLOYEE.DESIGNATION',':M_EMPLOYEE.JOIN_DATE',':M_EMPLOYEE.RELEIVING_DATE',':M_EMPLOYEE.DEPTCODE',
:M_EMPLOYEE.NETSAL,:M_EMPLOYEE.MOBIL_NO,:M_EMPLOYEE.ALT_MOBIL_NO,':M_EMPLOYEE.PERS_MAILID',':M_EMPLOYEE.OFF_MAILID',
':M_EMPLOYEE.GENDER',':M_EMPLOYEE.FATHER_NAME',':M_EMPLOYEE.MARITAL_STATUS',':M_EMPLOYEE.EDU_QUALIFY',':M_EMPLOYEE.BLOOD_GROUP',
':M_EMPLOYEE.PAN_NUMBER',':M_EMPLOYEE.BANK_CODE',:M_EMPLOYEE.ACC_NO,':M_EMPLOYEE.PASS_STATUS',
':M_EMPLOYEE.PASS_NUMBER',':M_EMPLOYEE.PAYMODE',':M_EMPLOYEE.EMP_PIC');
in my above insert code- (:M_EMPLOYEE is my block name) &(.EMP_ID and all the other columns are ITEM NAME)
i get an error like FRM-40735:when_button_pressed trigger raised unhandled exception ORA-12899
is there any other way to insert my data into my database if i use webutil package.
please give me your suggestion, thanks in advance!!! have a nice day