OCIBindByName Help Needed
| From: | Roger Spears | Date: | Mon, 20 Oct 2003 19:21:25 +0000 |
| Subject: | OCIBindByName Help Needed | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31201@lists.php.net to get a copy of this message | ||
Hello,
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??
$DB_Resource = OCIPLogon($user,$pass,$db);
$Clob = OCINewDescriptor($DB_Resource, OCI_D_LOB);
$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);
OCIExecute($Query_Resource, OCI_DEFAULT);
$Clob->free();
OCIFreeStatement($Query_Resource);
Please help preserve my sanity,
Roger