getting message: oci_execute(): ORA-00942: table or view does not exist

@ahmed Haroon,

I noticed that you had two 'save_queries' in the database.php file.  Was that a typo?

thanks @php_rocs for your reply, i failed to get two 'save_queries' please guide me for this, I want to have to connect multiple databases, here first one is 'oracle' and second is 'mysql' ( i am not trying to teach you as you are far more experienced ), are these correct entries? if not how i can resolve the problem, all necessary files i have uploaded here. if needed i can upload here a zip file of complete project.

my current modified ( as @InsiteFX referred to link for PDO-oci ) is now look like below  ( entry for mysql database is same in database.php file ):

PHP Code:

$active_group = 'oracle';
$query_builder = TRUE;

$db['oracle'] = array(
    'dsn'   => 'oci:dbname=(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclpdb)
    )
  )',
    'hostname' => '',
    //'hostname' => 'localhost',
    'username' => 'hr', 
    'password' => 'hr',
    'database' => '',
    'dbdriver' => 'oci8',
    'dbprefix' => '',
    'pconnect' => FALSE,
    'db_debug' => (ENVIRONMENT !== 'production'),
    'cache_on' => FALSE,
    'cachedir' => '',
    'char_set' => 'utf8',
    'dbcollat' => 'utf8_general_ci',
    'swap_pre' => '',
    'encrypt' => FALSE,
    'compress' => FALSE,
    'stricton' => FALSE,
    'failover' => array(),
    'save_queries' => TRUE
); 


but it is showing error as below  (only first lines from both errors):

A PHP Error was encountered
Message: oci_connect(): ORA-01017: invalid username/password; logon denied

A Database Error Occurred
Unable to connect to your database server using the provided settings.

I can connect with same credentials through SQL Plus (above dsn entry is copy pasted from tnsnames.ora file)

please help.
regards

EDIT: Sorry for inconvenience, I checked again database.php and found what "two save_queries" mean, I have removed 2nd entry but still getting same error as mentioned above.