Upload file problem
| From: | Kevin Leier | Date: | Mon, 18 Dec 2000 20:35:27 +0000 |
| Subject: | Upload file problem | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-5328@lists.php.net to get a copy of this message | ||
I am having problems uploading files from a web form and saving them in a
LOB field in Oracle 8i (8.1.6). I am using PHP v4.03pl1 and have tried on
both NT 4 and Solaris 8 using Apache web server. Everything works fine for
files under about 4MB, but anything larger gets the following error:
"Warning: OCILobWrite: ORA-27052: unable to flush file data SVR4 Error: 11:
Resource temporarily unavailable Additional information: 3 in
/uploadpage.php on line X"
I have tried adjusting the following items in the php.ini with no effect:
max_execution_time
memory_limit
post_max_size
upload_max_filesize
Here is the code for the page:
==============================================
$sql = "INSERT INTO storage(id,content) ";
$sql .= " VALUES (id_seq.NEXTVAL,EMPTY_BLOB())";
$sql .= " RETURNING content INTO :content";
$lob = OCINewDescriptor($db->conn,OCI_D_LOB);
$stmt = OCIParse($db->conn, $sql);
OCIBindByName($stmt, ':content', &$lob, -1, OCI_B_BLOB);
OCIExecute($stmt, OCI_DEFAULT);
if ($lob->savefile($upfile))
{
OCICommit($db->conn);
}
else
{
$msg = "Failure!";
}
==============================================
Any ideas?
Thanks in advance.