How to SELECT data from Oracle using PHP

Question

Im using ORACLE to select the user that Lock a table, the query works fine, but when I try to retrieve the results, thrown me an error.

$c = ' SELECT oracle_username os_user_name, locked_mode, object_name, object_type FROM V$LOCKED_OBJECT lo,DBA_OBJECTS do'." WHERE lo.object_id = do.object_id AND do.object_name='CLIENTS'";

$s = oci_parse($conn_s, $c );
    oci_execute($s);


    while($res = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){
        //var_dump($res);
        $check = $res['OS_USER_NAME'];
    }
echo $check;

how can i retrieve the values;

You can print the query and run in your database directly. so that you can come to know about kind of error. In future, you can able to resolve if you get what is the error and also if you feel it's easy.. — Punitha Subramani, Apr 05 '19 at 21:26
Perhaps permissions? What's the error...those views require more permissions — Ctznkane525, Apr 05 '19 at 21:38

score 0 · Answer 1 · answered Apr 05 '19 at 21:20

0

You Should have a comma oracle_username os_user_name, like this:

$c = ' SELECT oracle_username, os_user_name, locked_mode, object_name, object_type FROM V$LOCKED_OBJECT lo,DBA_OBJECTS do'." WHERE lo.object_id = do.object_id AND do.object_name='CLIENTS'";

answered Apr 05 '19 at 21:20

That wouldn't necessarily produce an error...it would just create an alias – Ctznkane525 Apr 05 '19 at 21:37

score 0 · Answer 2 · answered Apr 05 '19 at 21:35

If you using two different tables and you are retrieving the column name, we want to tell to database which table column's we want to SELECT. For example lo.oracle_username, do.os_user_name.

$c = "SELECT oracle_username, os_user_name, locked_mode, object_name, object_type FROM V$LOCKED_OBJECT lo,DBA_OBJECTS do WHERE lo.object_id = do.object_id AND do.object_name='CLIENTS'";

$s = oci_parse($conn_s, $c );
  $res = oci_execute($s);


    while($res = oci_fetch_array($s, OCI_ASSOC+OCI_RETURN_NULLS)){
        //var_dump($res);
        $check = $res['OS_USER_NAME'];
    }
echo $check;

How to SELECT data from Oracle using PHP

2 Answers2