ORA-01756quoted string not properly terminated
916675Jun 2 2012 — edited Jun 2 2012Hi
I am using Oracle11g and also using Vijeo Citect (cicode).Here I am using Cicode as a front end.
To push the values of tags I wrote this query but it gave following error.
Here all attributes are string datatypes.
INSERT INTO SCADA_MASTER(LOC_ID,LOC_NAME,DATETIME,LEVEL_TANK,CHL_TANK,TOTALISER_INFLOW,FLOW_DISTRIBUTION1) VALUES('"+sNo+"','"+sLoc+"','"+Date(2)+" "+TimeToStr(TimeCurrent(),0)+"','"+RealToStr(LVL_HANUMAYYANAGAR,4,2)+"','"+RealToStr(CHL_HANUMAYYANAGAR,4,2)+"','"+RealToStr(HANUMAYYANAGAR_TOTALISER_INFLOW,4,2)+"',
'"+RealToStr(FLOW_DISTRIBUTION_HANUMAYYANAGAR,4,2)+"')
here i am pushing the tag values of specific device
but its showing
ERROR : 1756[Microsoft][ODBC driver for oracle][Oracle]ORA-01756 quoted string not properly terminated