CodeIgniter Forums
Error Mesage from oci8 ocifetchinto() - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Error Mesage from oci8 ocifetchinto() (/thread-2459.html)



Error Mesage from oci8 ocifetchinto() - El Forum - 08-07-2007

[eluser]krasnik[/eluser]
Quote:Severity: Warning

Message: ocifetchinto() expects parameter 1 to be resource, null given

Filename: oci8/oci8_result.php

Line Number: 159

I get this message while doing this with the DB-Driver oci8:

Code:
$this->db->select('*');
    $this->db->from('TABLE');

    $query = $this->db->get();
    $array = $query->result_array();

I get all the results correctly out of the database, but also i this this error message. What's wrong here?

btwe.: i'm around here some time now and i like CI more and more. I use CI for my home pleasure with mysql (with works great) but now i have to use it for work and the oracle driver (with makes some problems). Please help me otherwise i'm forced to use PERL for web programming and that sucks Wink.

Thank you!


Error Mesage from oci8 ocifetchinto() - El Forum - 08-07-2007

[eluser]chobo[/eluser]
You might want to check to see if that db driver is supported. I'm not sure where to check though Sad


Error Mesage from oci8 ocifetchinto() - El Forum - 08-08-2007

[eluser]krasnik[/eluser]
In the database.php oci8 is not listed as supported driver, but the driver is shipped with the official release of CI and a lot of people here using this.


Error Mesage from oci8 ocifetchinto() - El Forum - 08-09-2007

[eluser]krasnik[/eluser]
No one knows about this db-driver?

I think it's only about initializing a variable/object but i don't know how ...


Error Mesage from oci8 ocifetchinto() - El Forum - 08-16-2007

[eluser]phpworker[/eluser]
Hi there, I have simmilar problems with oci8 and it seems the reason is in CI library, because I can read from db directly using oci8 php functions. Anyway I am thinking on writing the library from scratch.


Error Mesage from oci8 ocifetchinto() - El Forum - 08-16-2007

[eluser]krasnik[/eluser]
Yes, i wrote a small, ugly helper to be able to work with oracle. It's not worth to show here but i use the original oracle functions from php itself and it works.

There must be some uninitialized value. Sadly I'm still not so familiar with all this to (re)write/update the library myself.


Error Mesage from oci8 ocifetchinto() - El Forum - 09-07-2007

[eluser]Bobtorious[/eluser]
I am seeing this as well with Code Igniter 1.5.4. This is strange as I didn't get this error with versions of CI before 1.5.


Error Mesage from oci8 ocifetchinto() - El Forum - 10-24-2007

[eluser]mhyk[/eluser]
I am also having a similar problem with that. I think that the problem is in the oci8_result.php. Is there a way you can help me with that?


Error Mesage from oci8 ocifetchinto() - El Forum - 10-25-2007

[eluser]crossett[/eluser]
Move the line of code that reads “$RES->num_rows = $RES->num_rows();” below the if block in system/database/DB_driver.php. It is around line 325.

$driver = $this->load_rdriver();
$RES = new $driver();
$RES->conn_id = $this->conn_id;
$RES->result_id = $this->result_id;

if ($this->dbdriver == ‘oci8’)
{
$RES->stmt_id = $this->stmt_id;
$RES->curs_id = NULL;
$RES->limit_used = $this->limit_used;
}

$RES->num_rows = $RES->num_rows();


Error Mesage from oci8 ocifetchinto() - El Forum - 10-25-2007

[eluser]mhyk[/eluser]
thanks. You have helped me a lot...