[eluser]Unknown[/eluser]
halo all,
i have some problem with sql statement that connect to oracle.
I'm using CI 1.7.1 n oracle XE 9.
i have an oracle view, just call it myView.
this is database config that i used:
$active_group = "siproltrn";
$active_record = TRUE;
$db['siproltrn']['hostname'] = "//localhost/xe";
$db['siproltrn']['username'] = "siprol2";
$db['siproltrn']['password'] = "siprol2";
$db['siproltrn']['database'] = "";
$db['siproltrn']['dbdriver'] = "oci8";
$db['siproltrn']['dbprefix'] = "";
$db['siproltrn']['pconnect'] = TRUE;
$db['siproltrn']['db_debug'] = TRUE;
$db['siproltrn']['cache_on'] = FALSE;
$db['siproltrn']['cachedir'] = "";
$db['siproltrn']['char_set'] = "utf8";
$db['siproltrn']['dbcollat'] = "utf8_general_ci";
rank controller :
private function ranking(){
$sql = "SELECT * FROM SIPROL2.myView";
$query = $this->rank_model->getRanking($sql);
}
rank_model model :
function getRanking($sql){
$rank = $this->load->database('siproltrn', true);
$query = $rank->query($sql);
return $query;
}
the return from CI:
A Database Error Occurred
Error Number:
SELECT * FROM SIPROL2.myView
but is okay if i selected data from table, but from view always error.
please help me,.. I'm from Indonesia sorry if my English is not good enough