Hello you can not insert a lob this way. Refer to the php manual pages at http://www.php.net/oci And search for Example 3. Inserting data into a CLOB column Vincent -----Original Message----- From: Rosen [mailto:rosen@xxxxxxxxxxxxxx] Sent: jeudi 5 octobre 2006 14:43 To: php-db@xxxxxxxxxxxxx Subject: Problem with insert BLOB into Oracle Hi, I have problem with inserting into BLOB field in Oracle 10: insert into some_table(DESC) values ( '$txt') The DESC field type is "LONG RAW" The $txt variable contains large text, whitch is extracted from another table field with same type. When I read field DESC and print it, there is no problems, but when try to insert I receive an error:"Error: ORA-01465: invalid hex number" Can someone help ? Thanks, Rosen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
