Welcome Guest, Not a member yet? Register   Sign In
how to use CI_DB_oci8_result
#1

[eluser]albertone01[/eluser]
Hello,
i've got a problem using CI_DB_oci8_result with stored_function or stored_procedures.

This is my code:

Code:
$curs = FALSE;
$return = array ('name' => ':result', 'value' => &$curs, 'length' => -1, 'type' => OCI_B_CURSOR);
$params[] = array ('name' => ':p_day', 'value' => '18/06/2009' );
$this->db->stored_function('PKG_WEB_ORDERS', 'FUN_GET_ALL_ORDERS' , $return, $params);
$this->db->execute_cursor();
while ($data = oci_fetch_array($this->db->curs_id, OCI_ASSOC)) {
var_dump($data);
}
Instead of using "while ($data = ...." i would like to use CI_DB_oci8_result functions like result_array() ...

But I don't know how!

It seems that it is only possible using the syntax: $this->db->query(...);

Any ideas???




Theme © iAndrew 2016 - Forum software by © MyBB