Re: oracle trouble

On Tue, Aug 29, 2000 at 11:09:15AM +0200, Sebastian Stadtlich wrote: > hi > > i'm stuck with a oracle 8 problem. > > > -----------<cut>---------------- > $mailtext="i hate oracle when it makes my life more difficuilt"; > $conn = OCILogon($db_user,$db_pass); > > $tmpsql = "update Nutzer > set Vorname='$vorname', > Name='$nachname', > Firma='$firma', > ZielID=$ZielID, > UntID=$UntID, > System='$system', > Browser='$browser', > Stadt='$ort', > PLZ='$plz', > land='$land', > Strasse='$strasse', > EMail='$email', > Telefon='$telefon', > fax='$telefax', > WebID=$WebID, > broschuere=:broschuere, > Datum=$zeit, > www='$webadresse', > anrede='$anrede' > where NutzerID=$Nutzkeks"; > $stmt = OCIParse($conn,$tmpsql); > $mailtext = OCINewDescriptor($conn,OCI_D_LOB); > /* line :200*/ > OCIBindByName($stmt,":broschuere",&$mailtext,-1,OCI_B_CLOB); OCIExecute($stmt,OCI_DEFAULT); $mailtext->save("your text"); OCICommit($stmt); > /* line :202*/ > OCIFreeStatement($stmt); > OCILogoff($conn); > > > -----------<cut>---------------- > i get the following error : > OCIStmtExecute: ORA-22275: invalid LOB locator specified in xxx on line 202 > > if i change line 200 to > $mailtext = OCINewDescriptor($conn,OCI_D_LOB); > the only thing that is inserted in the field 'BROCHUERE' is ':brochuere' > > i must be missing something here...... > > Sebastian Stadtlich > mediaworx BERLIN AG > almstadtstraße 9-11 > 10119 berlin > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Thies C. Arntzen "One Big-Mac, Small Fries and a Coke!" Digital Collections Phone +49 40 235350 Fax +49 40 23535180 Hammerbrookstr. 93 20097 Hamburg / Germany