Roger Spears wrote:
I've been working on this all day. I'm trying to insert some text ($essay) into a CLOB field (essay) in my table (clob_test).

Can someone please tell me why the following PHP code returns ORA-01036: illegal variable name/number? Better yet, please tell me how to fix it??

$Query_Resource = OCIParse($DB_Resource, "INSERT INTO clob_test (firstName,lastName,essay) VALUES ('Roger','Dodger','$essay')");

OCIBindByName($Query_Resource, ':essay', &$Clob, -1, OCI_B_CLOB);


The error is probably occurring because there isn't a colon prefixed hard coded
placeholder (aka bind variable) in the insert statement.

Did my reply to your question last week reach you?  It contained sample
code for inserting a CLOB.  See


PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to