Accessibility

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.

AlertThis content requires Flash

To view this content, JavaScript must be enabled, and you need the latest version of the Adobe Flash Player.

Download the free Flash Player now!

Get Adobe Flash Player

Creative Commons License

Search Support


Document Details

ID:kb408950

Products Affected:

coldfusion