/** * getCursor. Returns a cursor from the datbase * * @access public * @return cursor id */ function get_cursor() { $this->curs_id = ocinewcursor($this->conn_id); return $this->curs_id; }
/** * getCursor. Returns a cursor from the datbase * * @access public * @return cursor id */ function getCursor() { return @ocinewcursor($this->conn_id); }
//Declare cursor variable $mycursor = ociparse($conn, "begin getPotisions(:curs,'{$alin1}'); end;"); // prepare procedure call ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR); // bind procedure parameters $ret = ociexecute($mycursor); // Execute function $ret = ociexecute($outrefc); // Execute cursor $nrows = ocifetchstatement($outrefc, $pos1); // fetch data from cursor ocifreestatement($mycursor); // close procedure call ocifreestatement($outrefc); // close cursor $outrefc = ocinewcursor($conn); //Declare cursor variable $mycursor = ociparse($conn, "begin getPotisions(:curs,'{$alin2}'); end;"); // prepare procedure call ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR); // bind procedure parameters $ret = ociexecute($mycursor); // Execute function $ret = ociexecute($outrefc); // Execute cursor $nrows = ocifetchstatement($outrefc, $pos2); // fetch data from cursor ocifreestatement($mycursor); // close procedure call ocifreestatement($outrefc); // close cursor
ocidefinebyname(); ocierror(); ociexecute(); ocifetch(); ocifetchinto(); ocifetchstatement(); ocifreecollection(); ocifreecursor(); ocifreedesc(); ocifreestatement(); ociinternaldebug(); ociloadlob(); ocilogoff(); ocilogon(); ocinewcollection(); ocinewcursor(); ocinewdescriptor(); ocinlogon(); ocinumcols(); ociparse(); ociplogon(); ociresult(); ocirollback(); ocirowcount(); ocisavelob(); ocisavelobfile(); ociserverversion(); ocisetprefetch(); ocistatementtype(); ociwritelobtofile(); ociwritetemporarylob();