oracle trouble
| From: | Sebastian Stadtlich | Date: | Tue, 29 Aug 2000 09:09:15 +0000 |
| Subject: | oracle trouble | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-14076@lists.php.net to get a copy of this message | ||
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);
/* 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