Welcome Guest, Not a member yet? Register   Sign In
getting message: oci_execute(): ORA-00942: table or view does not exist
#22

(This post was last modified: 11-15-2018, 09:31 PM by Ahmed Haroon.)

thanks a lot @InsiteFX for your help, appreciate your passion Smile. I copy/pasted your provided entries, saved and run but it is showing as below:  ( this message: table or view does not exist  i think it is connecting to database with given credentials but for some reason failed find the table 'departments' i am using in model ), even I stop WAMP after modifying database.php and start it again but didn't worked.

Code:
A PHP Error was encountered

Severity: Warning

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

Filename: oci8/oci8_driver.php

Line Number: 286

Backtrace:

File: C:\wamp64\www\myproject\application\models\Dept_model.php
Line: 15
Function: get

File: C:\wamp64\www\myproject\application\controllers\Depts.php
Line: 8
Function: getDept

File: C:\wamp64\www\myproject\index.php
Line: 315
Function: require_once

Code:
A Database Error Occurred

Error Number: 942

ORA-00942: table or view does not exist

SELECT * FROM "departments"

Filename: C:/wamp64/www/myproject/system/database/DB_driver.php

Line Number: 691

is there anything special i have to take care... like installation or copy some file like any .dll etc. for oci8 ? as mentioned earlier I have installed database 12c Release 2 and off course the same machine not need to install any oracle client.

regards
Reply


Messages In This Thread
RE: getting message: oci_execute(): ORA-00942: table or view does not exist - by Ahmed Haroon - 11-15-2018, 09:04 PM



Theme © iAndrew 2016 - Forum software by © MyBB