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,
                 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
OCIBindByName ($sql_statement, ":commentstemp", &$clob, -1, OCI_B_CLOB);

// execute SQL query
OCIExecute($sql_statement,OCI_DEFAULT) or die("Couldn't execute
// Commit Statement
$result = OCICommit($connection);

The SQL statement works fine when I remove the CLOB portion so I know
the rest is correct.

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]

Reply via email to