| urgent help needed [message #77211] |
Tue, 16 November 2004 21:33  |
Arjun
Messages: 17
Registered: April 2001
|
Junior Member |
|
|
Hi,
I was getting this error ORA-01756(Quoted string not terminated poperly) when i ran my query...
Its a dynamice query which runs..Pasting the query below:
SELECT COUNT(DISTINCT(CLFI))
FROM UNAGED_FAC_STATE WHERE CLFI_TYPE = :clfi_type_key AND ";
The below query gets appended to the query above:
inStr = " CLFI IN (";
inStr += "'" + clfiList[[0]] + "'";
for(int i=1; i< clfiList.entries(); i++)
inStr += ", '" + clfiList[[i]] + "'";
inStr += ")";
Could you tell me why this error gets generated
|
|
|
|
| Re: urgent help needed [message #77238 is a reply to message #77211] |
Tue, 23 November 2004 19:19  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
Print the complete statement after constructing it to
screen/file for inspection. If you still cannot
spot the problem, cut and paste it into a SQL*Plus
session, and try to execute it. SQL*Plus will tell on
what line the problem is.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
