[PHP-DB] OCIBindByName Help Needed

2003-10-20 Thread Roger Spears 
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

Re: [PHP-DB] OCIBindByName Help Needed

2003-10-20 Thread Christopher Jones 
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.dbarticle=31139
Chris

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php