Hi folks. I am getting a bizarre error when trying to insert CLOB data into my Oracle 9i database. (Using PHP4 on Apache 1.3.20) Error refers to a missing 'comma'?! Here is the exact error: Warning: OCIStmtExecute: ORA-00917: missing comma in /www/htdocs/Etrack/oracle_operations.php on line 52 Couldn't execute statement. Here is the code: // Set Clob variable $clob = OCINewDescriptor($connection, OCI_D_LOB); $sql = "INSERT INTO INCIDENT (incident, project, abstract, owner, reporter, state, priority, severity, type, open, supportinc, product, version, build, component, comments) VALUES (INCIDENT_SEQ.NEXTVAL, '$project', '$textfieldabstract', '$owner', '$reporter', '$state', '$priority', '$severity', '$type', TO_DATE(SYSDATE, 'YYYY/MM/DD HH24:MI:SS'), '$supportinc', '$product', '$version', '$build', '$component',comments = empty_clob()) returning comments into :commentstemp"; // parse SQL statement $clob = OCINewDescriptor($connection, OCI_D_LOB); $sql_statement = OCIParse($connection,$sql) or die("Couldn't parse statement."); OCIBindByName ($sql_statement, ":commentstemp", &$clob, -1, OCI_B_CLOB); // execute SQL query OCIExecute($sql_statement,OCI_DEFAULT) or die("Couldn't execute statement."); $clob->save($comments); // Commit Statement $result = OCICommit($connection); The SQL statement works fine when I remove the CLOB portion so I know the rest is correct. HELP!!!! Tom Tsongas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]