OCI8 query issue

[eluser]Unknown[/eluser]
Seem to run into an issue i cannot seem to solve.

Code:

$dbhandle = $this->load->database($database,TRUE);
$dbhandle->query("SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS WHERE GRANTED_ROLE LIKE '%$project'");

This works, but when i do a result or row i get this:

Code:

$result = $dbhandle->result();

PHP Fatal error: Call to undefined method CI_DB_oci8_driver::result()

[eluser]Unknown[/eluser]
Fixed, i must be low on coffee

$query = $dbhandle->query("SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS WHERE GRANTED_ROLE LIKE '%$project'");
$result = $query->row();

had to put it into a variable...

[eluser]Sixer[/eluser]

Code:

$query = $dbhandle->query("SELECT GRANTED_ROLE FROM USER_ROLE_PRIVS WHERE GRANTED_ROLE LIKE '%$project'");

$results = $query->result();