any oci8/php5 people awake out there?..yeah yeah.. I submitted to php forum

[Fred Silsbee]

Don't wake up the leprechaun since this post is a little out of place

but we have so many bright guys here...

The code below doesn't do the insert into Oracle 11g1.

I've tried the insert statement in a session:

[oracle at LMKIII log_book]$ sqlplus landon/<PassWord>

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 

$db = "(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SID = FSGDNSID)
   )
)";
if ($conn=oci_connect('fred', '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!