Error -1861: ORA-01861: literal does not match format string
hi
i am getting the ORA-01861: literal does not match format string. However my code is mentioned below
runtime_call:='insert into mss_examination (exam_id,examination_name,registration_no,examination_session,roll_no,stream_id,remarks,board,vouchar,examinationyear)values (:exam_id,:examination_name,:registration_no,:examination_session,:roll_no,:stream_id,:remarks,:board,:vouchar,:examinationyear)';
DBMS_SQL.PARSE(l_cursor, runtime_call, DBMS_SQL.NATIVE);
DBMS_SQL.BIND_VARIABLE(l_cursor, ':exam_id', xmlstr(1));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':examination_name',xmlstr(2));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':registration_no', xmlstr(3));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':examination_session',xmlstr(4));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':roll_no', xmlstr(5));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':stream_id',xmlstr(6));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':remarks',xmlstr(7));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':board',xmlstr(8));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':vouchar',xmlstr(9));
DBMS_SQL.BIND_VARIABLE(l_cursor, ':examinationyear', xmlstr(10));
l_data:=DBMS_SQL.execute(l_cursor);
Please help.