[eluser]Unknown[/eluser]
Hello everyone,
I am getting the below error in CodeIgniter in my attempt to execute this query, can anyone kindly help me out? I am trying to read data from Oracle database.
CI Version : 2.1.3
Platform : Ubuntu
This is my code:
Code:
public function __construct(){
$this->CI =& get_instance();
$this->_KISS_DB = $this->CI->load->database('kiss', TRUE);
}
function current_semester(){
$strSQL = "SELECT DISTINCT
COURSE_DETAIL_SUBJECT.COURSE_CODE,
COURSE_DETAIL_SUBJECT.INTAKE_NUMBER,
COURSE_DETAIL_SUBJECT.STUDY_MODE,
COURSE_DETAIL_SUBJECT.SEMESTER_NO,
COURSE_DETAIL_SUBJECT.SUBJECT_CODE,
SUBJECT_MASTER_TABLE.SUBJECT_DESCRIPTION
FROM KISS.STUDENT_COURSE_MASTER, KISS.COURSE_DETAIL_SUBJECT, KISS.SUBJECT_MASTER_TABLE
WHERE STUDENT_COURSE_MASTER.IC_PASSPORT = '931224016147'
AND STUDENT_COURSE_MASTER.COLLEGE_REG_NO = '177263-T'
AND STUDENT_COURSE_MASTER.COURSE_CODE = COURSE_DETAIL_SUBJECT.COURSE_CODE
AND STUDENT_COURSE_MASTER.INTAKE_NUMBER = COURSE_DETAIL_SUBJECT.INTAKE_NUMBER
AND STUDENT_COURSE_MASTER.STUDY_MODE = COURSE_DETAIL_SUBJECT.STUDY_MODE
AND STUDENT_COURSE_MASTER.SEMESTER_NO = COURSE_DETAIL_SUBJECT.SEMESTER_NO
AND STUDENT_COURSE_MASTER.COLLEGE_REG_NO = COURSE_DETAIL_SUBJECT.COLLEGE_REG_NO
AND STUDENT_COURSE_MASTER.SUBJECT_CODE = SUBJECT_MASTER_TABLE.SUBJECT_CODE
AND STUDENT_COURSE_MASTER.COLLEGE_REG_NO = SUBJECT_MASTER_TABLE.COLLEGE_REG_NO
AND SYSDATE NOT BETWEEN STUDENT_COURSE_MASTER.PERIOD_FROM AND STUDENT_COURSE_MASTER.PERIOD_TO
AND COURSE_DETAIL_SUBJECT.SUBJECT_CODE NOT IN
(SELECT SUBJECT_CODE
FROM STUDENT_COURSE_DETAIL_SUBJECT
WHERE CURRENT_STATUS = 'COMPLETED'
AND IC_PASSPORT = '931224016147')";
$query = $this->_KISS_DB->query($strSQL);
foreach ($query->result() as $row)
{
echo $row->COURSE_CODE;
}
}
database connection string:
Code:
$active_group = "kiss";
$active_record = TRUE;
$dbhost = "xxx.xxx.xxx.xx"; //host
$dbport= "1521"; //port default is 1521
$dbname = "xyz"; //name of database
$dbuser = "me"; //db user with all priviliges
$dbpassword = "mypassword"; //password of user
$dbConnString = "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = ". $dbhost .")(PORT = ". $dbport .")))(CONNECT_DATA =(SERVICE_NAME = ". $dbname .")))";
$db['kiss']['hostname'] = $dbConnString;
$db['kiss']['username'] = $dbuser;
$db['kiss']['password'] = $dbpassword;
$db['kiss']['database'] = $dbname;
$db['kiss']['dbdriver'] = 'oci8';
$db['kiss']['dbprefix'] = '';
$db['kiss']['pconnect'] = FALSE;
$db['kiss']['db_debug'] = FALSE;
$db['kiss']['cache_on'] = FALSE;
$db['kiss']['cachedir'] = '';
$db['kiss']['char_set'] = 'utf8';
$db['kiss']['dbcollat'] = 'utf8_general_ci';
$db['kiss']['swap_pre'] = '';
$db['kiss']['autoinit'] = TRUE;
$db['kiss']['stricton'] = FALSE;
Error: Fatal error: Call to a member function result() on a non-object in
