'row is not inserting due to SP2-0552 error

I was trying to insert a row in a table. The below given error occurred while inserting

I don't know for what reason it occurred 

SQL> insert into priya1 values ('CB','000304105000','A023596','MSC','A',05/7/2013
 5:33:57 AM);

SP2-0552: Bind variable "33" not declared.

sqloracle


Solution 1:[1]

i found an another way for this problem i solved using the given below query and then i inserted rows without adding to_date

alter session set nls_date_format='yyyy/mm/dd hh:mi:ss am';

Solution 2:[2]

it may be case when data contains single quote also produces this error for date column. in that case replace single quote with two single quotes. then record will insert

Solution 3:[3]

put the date time value in single quote

insert into priya1 values ('CB','000304105000','A023596','MSC','A','05/7/2013
 5:33:57 AM');

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 vishnupriya
Solution 2 Balasubramanian Ramamoorthi
Solution 3 donstack

Related Questions