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]
