[eluser]msangapu[/eluser]
I am having some trouble running queries on an oracle DB.
First of all, I am not sure if my connection properties are set properly. I know before it was saying "unable to connect" and now it no longer says that, but I get an error when I try to run a query.
Code:
A Database Error Occurred
Error Number:
SELECT * FROM "bb_course_list"
And here is my connection settings from database.php
Code:
putenv('ORACLE_HOME=/usr/local/oracle_php');
$db['oracle']['hostname'] = "PROD"; //PROD is actually the name of the SID
$db['oracle']['username'] = "*******";
$db['oracle']['password'] = "*******";
$db['oracle']['database'] = "IDS";
$db['oracle']['dbdriver'] = "oci8";
$db['oracle']['dbprefix'] = "";
$db['oracle']['pconnect'] = FALSE;
$db['oracle']['db_debug'] = TRUE;
$db['oracle']['cache_on'] = FALSE;
$db['oracle']['cachedir'] = "";
$db['oracle']['char_set'] = "utf8";
$db['oracle']['dbcollat'] = "utf8_general_ci";
I work for an institution and we normally have to do the putenv command before we connect to the database.
The error does not list any number!! I googled for quite some time and kept getting the article hosted on abbett.org. I am not sure what I'm doing wrong.
Anyone with CI + Oracle experience?