Oracle and ADOdb
Posted: Fri Oct 14, 2005 5:01 am
Hi All
It was such a flippin mission to get oracle setup and working with ADOdb. Well, now that I get a connection to the database I have another problem. I have a function that returns the fields of a table:
If I vardump the $db connection, it is valid. And my oracle user that I created has dba, resource and connects rights. The namespace that I use does exist, and it is default to the user. The $field variable returns an empty Array.
So I cannot get the friggin fields for the table.
Is there anything else that I can check? Thanks, much appreciated.
It was such a flippin mission to get oracle setup and working with ADOdb. Well, now that I get a connection to the database I have another problem. I have a function that returns the fields of a table:
Code: Select all
/*
* Name: getTableFields
* Type: function
* Purpose: get the fields of a table.
* Parameters: getTableFields(string $table))
* Return: return (Array $fields);
* Usage:
$fields = $this-> getTableFields($table);
* Output Example: Array
*/
public function getTableFields($table)
{
$db = $this-> connection(); // connect to database
// $table = "tablenamespace.table";
$fields = $db-> MetaColumns($table); // get columns
$columns = sizeof($fields);
$this-> closeConnection($db); // close connection
return($fields); // return fields
} //public function getTableFields($table)So I cannot get the friggin fields for the table.
Is there anything else that I can check? Thanks, much appreciated.