Fred Silsbee wrote:
> 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!
>
>
>
>
>
One thing that jumps out at me is the insert query. You have:
$stid = oci_parse($conn, 'insert into log_book values ( TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8);');
which will probably not do what you want. You probably mean to have the
query in double quotes and the values in single quotes.
$stid = oci_parse($conn, "insert into log_book values ( TO_DATE('08/12/1973','MM/dd/YYYY'),'B-17','N5787G',1,1.8);");
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
