Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » urgent help needed
urgent help needed [message #77211] Tue, 16 November 2004 21:33 Go to next message
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 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: OCI and Oracle SESSIONS
Next Topic: Setting Request & Response Character set to UTF-8 in Oracle 9iAS Release 1
Goto Forum:
  


Current Time: Thu Mar 28 17:51:57 CDT 2024