[PHP] Showing tables (converting from MySQL to Oracle)

[Shane Presley]

Hello,

I've recompiled PHP to use Oracle, and been able to run a quick test
script that looks like...

<?php
if ($c=OCILogon("user", "pw", "server")) {
  echo "Successfully connected to Oracle.\n";
  OCILogoff($c);
} else {
  $err = OCIError();
  echo "Oracle Connect Error " . $err[text];
}
?>


So now I'm going through and converting my MySQL code to Oracle.  I've
finished the connect functions, but getting hung up on how to do
queries.  For example the first query wants to SHOW TABLES.  Not sure
how to do this with Oracle calls?

function get_tables($link) {
        $tableList = array();
        $query = "SHOW TABLES";
        $result = perform_query($query, $link);
        while($row = fetch_array($result)) {
                array_push($tableList, $row[0]);
        }

        return $tableList;
}


function perform_query($query, $link) {
        if($link) {
                $result = mysql_query($query, $link) or die('Query
failed: ' . mysql_error());
        }
        else {
                die('No DB link');
        }

        return $result;
}


Thanks!
Shane

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php