TechNote

Error "SQL command not properly ended' when using an Oracle OCI datasource" (ColdFusion 8)

Issue

---

When an insert statement of the following format is initiated on an Oracle datasource configured using an OCI driver:

Insert into t1 () select * from t1

you receive the following error:

SQL command not properly ended' when using an Oracle OCI datasource

Reason

---

The OCI driver has some problems with metadata information.

Solution

---

Apply the hotfix by doing the following:

1. Download the hf801-75033.jar hotfix file and save it to your computer or server.
2. Log into the Coldfusion administrator.
3. Click System Information (the white 'i' in the blue circle) in the top right hand corner of the Coldfusion administrator.
4. In the update file section, browse or type the path to the hf801-75033.jar,and then click Submit Changes.
5. Restart Coldfusion.

Search Support

---