title: how to get sequence id of last inserted record in oracle 11g xe with php?
body: <p>here i am trying to insert a record as well as retrive last inserted sequence id but didn't get any success can anybody help me , guide me that how oracle works with php ?</p>
  
  <pre><code>$query = 'INSERT INTO hist_news (id,headline,reportedon,reportedby,loc,story,more,helperjson,refjson,createdt,createdby) VALUES(id.nextval, :headline, :reportedon, :reportedby , :loc , :story , :more , :helper , :ref , sysdate , :createdby) return id.nextval';
          $this-&gt;stmt = oci_parse($this-&gt;oci,$query);
          oci_bind_by_name($this-&gt;stmt,':headline',$headline);
          oci_bind_by_name($this-&gt;stmt,':reportedon',$reportedon);
          oci_bind_by_name($this-&gt;stmt,':reportedby',$reportedby);
          oci_bind_by_name($this-&gt;stmt,':loc',$loc);
          oci_bind_by_name($this-&gt;stmt,':story',$story);
          oci_bind_by_name($this-&gt;stmt,':more',$more);
          oci_bind_by_name($this-&gt;stmt,':helper',$helperjson);
          oci_bind_by_name($this-&gt;stmt,':ref',$refjson);
          if($re = oci_execute($this-&gt;stmt)){
              return $re;
          } else {
              return false;
          }
  </code></pre>