Retrieving Last Inserted ROWID In PHP/OCI

Question

Is it possible to retrieve the rowid of the last inserted Oracle row in PHP? I was trying: ``` $statement = oci_parse($conn, "INSERT INTO myTable (...) VALUES ( ...)"); $results = oci_execute($statement); while($row = oci_fetch_assoc($statement)) { $rowid = $row['ROWID']; } ``` With no luck. I'm getting the error define not done before fetch or execute and fetch at the fetch line.

Accepted Answer

Declare:

```
$var = "AAAV1vAAGAAIb4CAAC";
```

Use:

```
INSERT INTO myTable (...) VALUES ( ...)
RETURNING RowId INTO :p_val
```

Bind your variable to a PHP variable:

```
oci_bind_by_name($statement, ":p_val", $val, 18);
```

Retrieving Last Inserted ROWID In PHP/OCI

Solution

Problem