<p>By design, a cursor is a in memory result set. As a result set, it contains many records - or rows - and each row contains columns with values.</p>

<p>I think that is a good idea to define a class to abstract these rows - Zend_Db_Cursor_Row - as well, or make cursors behave as Zend_Db_Table_Rowset - as they share common behavior.</p>

<p>Any opinions?</p>

<p>Added the class skeleton. This code is not tested yet.</p>

<p>Re-assuming the proposal after a long break.</p>

<p>Just finished a new component draft, updating within a week.</p>

<p>I tried the alpha component and it seems that Statement is not well created, i get this error : <br />
Warning: oci_bind_by_name(): supplied argument is not a valid oci8 statement resource</p>

<p>Just updated this proposal. Uploaded the working class skeletons - see the Theory of Operation section.</p>

<p>The alpha version allow to bind a ref cursor in an Oracle statement and to fetch data from it as a rowset.</p>

<p>Next improvement is to allow object flavor access to the Zend_Db_Cursor_Row objects.</p>

<p>If you can, test it and give some feedback.</p>

<p>Thanks <ac:emoticon ac:name="smile" /></p>

<p>Zend_Db_Row can be accessed as an array ($row<ac:link><ri:page ri:content-title="'column'" /></ac:link>) and as an object ($row->column)</p>

<p>Just pushed the package draft in github, the link is <a href="http://github.com/brunitto/zend-db-cursor.git">http://github.com/brunitto/zend-db-cursor.git</a></p>

<p>Hello, good work. But in my opinion I believe there should be simpler, as previously stated by Brian, because the cursor in Oracle is a statement and this should be so treated for compatibility as other classes of stock are. If you create an abstract class for cursor depending on the interpretation can be confusing because its definition is sometimes a little differently in each bank, as being fit for a bank but not as a cursor.</p>

<p>How do I put this link: <a class="external-link" href="http://framework.zend.com/issues/browse/ZFINC-13">http://framework.zend.com/issues/browse/ZFINC-13</a> would leave here the implementation I made that solves this problem as yet have no knowledge of how to create a proposal I have just the patch same link above.</p>

<p>Following example of using already testing in Oracle 9i Release 2 (9.2):</p>

<p>SampleModel.php</p>

<ac:macro ac:name="code"><ac:plain-text-body><![CDATA[
/**

• Retorna o vínculo pelo CPF caso exista.
  *
• @param string $cpf
• @return Zend_Db_Statement
  */
  public function getVinculoByCPF($cpf)
  {
  $sql = "CALL CONSULTA_VINCULO_CPF(:cpf, :rs)";
  $stmt = $this->getDefaultAdapter()->prepare($sql);
  $stmt->bindParam(':cpf', $cpf);
  $stmt->bindParam(':rs', $rs, Zend_Db::PARAM_STMT);
  $stmt->execute();
  return $rs;
  }
  ]]></ac:plain-text-body></ac:macro>

<p>SampleController.php</p>

<ac:macro ac:name="code"><ac:plain-text-body><![CDATA[
$stmtVinculo = $objJuntaComercialModel->getVinculoByCPF($cpf);
$this->view->arrObjVinculo = $stmtVinculo->fetchAll();
]]></ac:plain-text-body></ac:macro>

<p>Patch:</p>

<ac:macro ac:name="code"><ac:plain-text-body><![CDATA[

1. 1. 1. Eclipse Workspace Patch 1.0
         #P Zend Framework
         Index: library/Zend/Db/Statement/Oracle.php
         ===================================================================
      • library/Zend/Db/Statement/Oracle.php (revision 22149)
        +++ library/Zend/Db/Statement/Oracle.php (working copy)
        @@ -115,6 +115,19 @@
        $type = SQLT_CHR;
        }

+ if($type == Zend_Db::PARAM_STMT){
+ $type = OCI_B_CURSOR;
+ $variable = @oci_new_cursor($this->_adapter->getConnection());
+ if (empty($variable))

+ }
+
// default value
if ($length === NULL)

+ foreach($this->_bindParam as &$value){
+ if(is_resource($value)
+ && get_resource_type($value) == "oci8 statement"){
+ $retvalCursor = @oci_execute($value, $this->_adapter->_getExecuteMode());
+ if ($retvalCursor === false)

+ $stmt = $value;
+ $value = clone $this;
+ $value->_stmt = $stmt;
+ }
+ }
+
return $retval;
}

]]></ac:plain-text-body></ac:macro>

<p>Archiving this proposal, feel free to recover it when you want to work on it again. For more details see <a href="http://framework.zend.com/wiki/display/ZFDEV/Archiving+of+abandoned+proposals+(Feb+5+2011)">this email</a>.</p>