SQL-Oracle Error "ends before converting the entire input string"

I insert some value into sql Oracle.

My request in procedure:

INSERT INTO CHAT_CUSTOMER(customerId, customerName, status, lastLogin, isAdmin)
VALUES (v_customerId, v_customerName, v_status, to_date(v_lastLogin, 'dd/MON/yyyy hh24:mi:ss'), v_isAdmin);

      

And I ran my procedure:

V_CUSTOMERID := '111';
V_CUSTOMERNAME := 'AAA';
V_STATUS := 'Busy';
V_LASTLOGIN := '08/AUG/2015 21:02:44';
V_ISADMIN := '1';

      

Then I get the error:

ORA-01830: date format picture ends before converting entire input string
ORA-06512: at line 11

      

I have searched for some threads related to this, but this did not solve my problem. I add "to_date" but it still doesn't work.

Is there something wrong here? Please explain to me and help me solve the problem.

+3


source to share


1 answer


You declared v_last_login as a date, then you do to_date on it when you insert. Try changing it so that the declaration on v_last_login is varchar2. Then check to see if it fails.



+1


source







All Articles