[eluser]CARP[/eluser]
Hi
I'm trying to load and use an oracle database within a specific model, but I'm getting errors.
Code:
class Model_peopledata extends CI_Model {
public $DB2;
function __construct()
{
parent::__construct();
$this->$DB2 = $this->load->database("myoracle", TRUE);
}
function get_all_rows()
{
$query = $this->$DB2->get('MYTABLEORVIEW');
return $query;
}
}
What's wrong? I'm getting:
Fatal error: Cannot access empty property in...
How should I load and use this custom database config within a model? And how should I unload this database or close the connection? Is this done automatically?
PD: Tried loading the oracle database from a controller, and works fine.
Thanks