I am inserting image data into blob data type

Anon

in Oracle...
in Php3 manual, I found it.
But it didn't work .
I just got an error message below.
....

ORA-22990: LOB locators cannot span transactions

I never know why.
Please, give me some advices.

My reference from php manual follows..

Line 23 got error.

$conn = OCILogon($user, $password);
19 $lob = OCINewDescriptor($conn, OCI_D_LO😎;
20 $stmt = OCIParse($conn,"insert into $table (id, the_blob) values(my_seq.NEXTVAL, EMPTY_BLOB()) returning the_blob into :the_blob");
21 OCIBindByName($stmt, ':the_blob', &$lob, -1, OCI_B_BLO😎;
22 OCIExecute($stmt);
23 if($lob->savefile($lob_upload)){
24 OCICommit($conn);
25 echo "Blob successfully uploaded\n";
26 }else{
27 echo "Couldn't upload Blob\n";
28 }
29 OCIFreeDescriptor($lob);
30 OCIFreeStatement($stmt);
31 OCILogoff($conn);

Anon

This is not the answer to your question!

All I'm wondering is why you want to put the images in the database.
Why not simple save the paths and other image info as chars and have the image somewhere on your server??

I'm not trying to explain something. I'm just curious.

Anon

Hi,

We are trying to connect to Oracle8 database using oci funtions but are not successful.

Regards

Kirti

Anon

you have to use OCI_DEFAULT in your OCIExecute command. I had to go onto IRC to find this out (it\'s not in the php manual part)

so like this:
OCIExecute($stmt, OCI_DEFAULT);

that will fix it.

Anon

Minju Park,

Just had the same problem myself today, here is the answer:

OCIExecute($stmt, OCI_DEFAULT);

You have auto commit turned on, that was my problem.

Chris