Error "SQL command not properly ended'' when using an Oracle OCI datasource" (ColdFusion 8)Products affected
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:
- Download the hf801-75033.jar hotfix file and save it to your computer or server.
- Log into the Coldfusion administrator.
- Click System Information (the white 'i' in the blue circle) in the top right hand corner of the Coldfusion administrator.
- In the update file section, browse or type the path to the hf801-75033.jar,and then click Submit Changes.
- Restart Coldfusion.
Doc ID
(kb408950)
Last updated
2009-04-06
Products affected
