any oci8/php5 people awake out there?..yeah yeah.. I submitted to php forum
Fred Silsbee
fredsilsbee at yahoo.com
Sun Nov 23 03:25:57 UTC 2008
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!
More information about the fedora-list
mailing list