Re: OCIBindByName Help Needed
| From: | Christopher Jones | Date: | Tue, 21 Oct 2003 01:39:30 +0000 |
| Subject: | Re: OCIBindByName Help Needed | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31212@lists.php.net to get a copy of this message | ||
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);Roger, 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 http://news.php.net/article.php?group=php.db&article=31139 Chris