Re: Undefined property - tableInfo on Oracle?

ok, http://pear.php.net/manual/en/core.db.tableinfo.php indicates that there is no method for retrieving table structure details on oracle database.. - not sure if that's due to 'not implemented' or 'not possible' Not knowing Oracle, you may be able to anwser that better than I can. regards Alan Alan Knowles wrote:

Subject: Undefined property From: mclinden@informed.net Date: Fri, 30 Aug 2002 11:35:52 -0400 I recently tried installing PEAR DV using the examples in the manual. I had one setback early on in that I had turned OFF short_open_tag but I turned it on AFTER the PEAR install and got further. Basically, I am accessing an Oracle 8i database and ran createTables.php and got the following:

Ok, Its not been tested AFAIK on oracle 8i, but there shouldnt be too many changes required. on line 152 of generator.php this line is commented out. //print_r($this->_definitions); if you turn it back on and send the results, It should begin to track down the problem. It looks like the pear db $database->tableInfo($table) is returning something unexpected. regards Alan

First, every TABLE.php included the line:

var $;         // ()

Which produced errors when I ran my test script. When I pulled these out, I got (with the following .ini)... [DB_DataObject]

database        = oci8://name:pass@mydb.host.net:1521/web

schema_location = /usr/lib/php/DB/DataObject/achdweb/DataObjects class_location = /usr/lib/php/DB/DataObject/achdweb/DataObjects require_prefix = DataObjects/

class_prefix    = DataObjects_

;table_example = example ;database_example = mysql://username:password@host/database extends_location =

;               string added to php file for 'include('DB/DataObject');'
;               usefull if you want to add an extra layer - eg. a table

level auth scheme..

;               optional    :: default = DB/DataObject.php

extends =

;               string used in Table_XXX extends YYYY {
;               usefull if you want to add an extra layer - eg. a table

level auth scheme..

;               optional    :: default = DB_DataObject

debug = 3

;               default debugging level

;production = 0

;                    this disables all debugging (so you cant set it run

time), and should

;                    improve performace

And the output from the createTables.php file is: <font color=ff0000> Notice: Undefined property: flags in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font><font color=ff0000> Notice: Undefined property: flags in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font><font color=ff0000> Notice: Undefined property: flags in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font><font color=ff0000> Notice: Undefined property: name in /usr/lib/php/DB/DataObject/Generator.php on line 346 </font><font color=ff0000> Notice: Undefined property: name in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font><font color=ff0000> Notice: Undefined property: type in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font><font color=ff0000> Notice: Undefined property: len in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font><font color=ff0000> Notice: Undefined property: flags in /usr/lib/php/DB/DataObject/Generator.php on line 349 </font>writing DataObjects_ZIPCODE Thanks in advance. Sean