Re: OCIBindByName Help Needed

>> ORA-01036: illegal variable name/number Make sure that the variable being bound is in the sql statement. -- Jon Kriek http://phpfreaks.com "Roger Spears" <roger@bgnet.bgsu.edu> wrote in message news:3F9435B5.70905@bgnet.bgsu.edu... > 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 >