upload php กับฐานข้อมูล oracle แล้ว error ครับ ช่วยทีครับผม
Code Warning: oci_execute() [function.oci-execute]: ORA-02289: sequence does not exist in C:\AppServ\www\AAAAA\PageUploadToOracle2.php on line 20
Code (PHP) <html>
<head>
<title>ThaiCreate.Com Tutorial</title>
</head>
<body>
<?
if($_FILES["filUpload"]["name"] != "")
{
//*** Insert Record ***//
$objConnect = oci_connect("project","1234","XE");
$lob = oci_new_descriptor($objConnect, OCI_D_LOB);
$strSQL = "INSERT INTO FILES ";
$strSQL .="(FILESID,NAME,FILESTYPE,FILESNAME) VALUES ";
$strSQL .="(seq_next_filesid.nextval,'".$_POST["txtName"]."' ";
$strSQL .=",'".$_FILES["filUpload"]["type"]."',EMPTY_BLOB()) RETURNING FILESNAME INTO :BLOBDATA";
$objParse = oci_parse($objConnect, $strSQL);
oci_bind_by_name($objParse, ':BLOBDATA', $lob, -1, OCI_B_BLOB);
$objExecute = oci_execute($objParse, OCI_DEFAULT);
$lob->savefile($_FILES['filUpload']['tmp_name']);
if($objExecute)
{
oci_commit($objConnect);
echo "Copy/Upload Complete<br>";
}
else
{
oci_rollback($objConnect);
echo "Copy/Upload is not Complete";
}
oci_free_descriptor($lob);
oci_free_statement($objParse);
oci_close($objConnect);
}
?>
<a href="PageUploadToOracle3.php">View files</a>
</body>
</html>
Tag PHP, Oracle
Date :
2011-12-21 09:25:30By :
payupatnaView :
1613Reply :
5
แก้ได้ละครับผมลืม create sequence seq_next_filesid
Date :
2011-12-21 10:20:50By :
payupatna
ขอโทษครับได้ละครับผมลืมเปลี่ยน
Date :
2011-12-21 10:25:21By :
payupatna
ปรับรูปก็ Resize ครับ
Date :
2011-12-21 20:23:18By :
webmaster
Server 00
Load balance : Server 00
