| PHP-Oracle getting inserted rowID [message #502449] |
Wed, 06 April 2011 06:59  |
 |
mrmcs
Messages: 1
Registered: April 2011
|
Junior Member |
|
|
Im using Oracle 10g and PHP5.x
on Data insert in return i need CUST_NO ID which is auto generated in database
<?php
if ($conn = oci_connect('scott','tiger', '192.168.0.225/XE')) {
$insert = "Insert into CUST (STORE_Name,CUST_TYPE_NO) values ('my store',2)";
$cursor = oci_parse($conn, $insert);
oci_execute($cursor);
oci_close($conn);
}
else
{
$err = oci_error();
echo "Oracle Connect Error " . $err['text'];
}
?>
-----------------------------------
My table structure is
Column Name Data Type Nullable Default Primary Key
CUST_NO NUMBER No - 1
STORE_Name Varchar2(25) No - -
CUST_TYPE_NO NUMBER No - -
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
