OCIBindByName Help Needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux