php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry
| From: | Fred Silsbee | Date: | Sun, 23 Nov 2008 03:12:25 +0000 |
| Subject: | php5/oci8/oracle 11g1 insert doesn't work ..updated..sorry | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-45689@lists.php.net to get a copy of this message | ||
The following code doesn't do the insert.
I've tried the insert statement in a session:
[oracle@LMKIII log_book]$ sqlplus landon/<PW>
SQL*Plus: Release 11.1.0.6.0 - Production on Sat Nov 22 16:01:39 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from log_book where actype='B-17';
no rows selected
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
<?php // File: anyco.php
require('anyco_ui.inc');
$db = "(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = LMKIIIGDNSID)
)
)";
if ($conn=oci_connect('landon', 'PWD',$db))
{
echo "Successfully connected to Oracle.\n";
}
else
{
$err = OCIError();
echo "Oracle Connect Error " . $err['message'];
}
$stid = oci_parse($conn, 'insert into log_book values (
TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8);');
$r = oci_execute($stid );
oci_commit($conn);
OCILogoff($conn);
echo "end";
?>
produces: Successfully connected to Oracle.end
This is my first php/oci8/oracle insert! What could be simpler! HELP!
In desperation, I used em to give myself every possible privilege !
Not good but after it works, I can go back and correct and learn privileges!
I rebooted and tried this again to no avail.
I suspected a commit problem but oci_execute has commit as default!
The table has no primary key defined since no values are unique.
I have a similar table with a row id!