Error inserting CLOB

From: Date: Thu, 30 Aug 2001 22:44:29 +0000
Subject: Error inserting CLOB
Groups: php.db 
Request: Send a blank email to php-db+get-12004@lists.php.net to get a copy of this message
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

« previous php.db (#12004) next »