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!

ORA-01756quoted string not properly terminated

916675Jun 2 2012 — edited Jun 2 2012
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2012
Added on Jun 2 2012
3 comments
6,803 views