OCIStmtExecute: ORA-00942: table or view does not

Anon

i found this error on belove script
i had php4+oracle8i+apache12 on redhat6.2

1 <?php
2 PutEnv("ORACLE_SID=oracle");
3 echo "DEBUG:--->connecting oracle ";
4 echo "DEBUG:--11111--------------------------<> ";
5 $connection = OCILogon("sys","change_on_install");
6 if ($connection == false){
7 echo "DEBUG:------2222----------------------<> ";
8 echo OCIError($connection).":".OCIError($connection)." ";
9 exit;
10 }
11
12
13 $query = "insert into emp values ('pppswami','pagel')";
14 $cursor = OCIParse($connection, $query);
15 if ($cursor == false){
16 echo OCIError($cursor).":".OCIError($cursor)." ";
17 exit;
18 }
19
20 $result = OCIExecute($cursor);
21 if ($result == false){
22 echo OCIError($cursor).":".OCIError($cursor)." ";
23 exit;
24 }
25
26 OCICommit($connection);
27 OCILogoff($connection);
28
29 echo "DEBUG:--->insert sucessfully in oracle ";
30 ?>
31

Anon

Hi,

As it says, table emp doesn't exist for user sys.

do a :
select * from tabs where table_name = 'EMP';

The output should be 0 row fetched !

So, create the table first or ensure you have access right to it!

Hth

JBL