Skip to Main Content

SQL & PL/SQL

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!

Error -1861: ORA-01861: literal does not match format string

user3520684Jul 7 2009 — edited Jul 7 2009
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 4 2009
Added on Jul 7 2009
4 comments
19,497 views