Error inserting CLOB
| From: | Tom Tsongas | 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