[Zope] ZOracleDA Weirdness

[Neill Cox]

Hi,

First of all the obligatory kudos to DC. What a cool product! Why did I ever
bother with CGI?!

Now for the problem: I'm using zope beta 1 to view Oracle Data Dictionary
tables, and I have some strange behaviour.

This code works fine
        <tr>
          <td><font size="-2"><!--#var COLUMN_NAME--></font></td>
          <td><font size="-2"><!--#var DATA_TYPE--></font></td>
          <td><font size="-2"><!--#var DATA_LENGTH null=""--></font></td>
          <td><font size="-2"><!--var DATA_PRECISION
null="N/A"--></font></td>
          <td><font size="-2"><!--var DATA_SCALE null=""--></font></td>
          <td><font size="-2"><!--#var NULLABLE--></font></td>
        </tr>

But if I uncomment (add the # to) the DATA_PRECISION and/or DATA_SCALE
columns Zope requests authorization before it will publish the DTML.

The underlying select is:

	SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE
		NULLABLE
	FROM ALL_TABLES
	WHERE table_name =
	  AND owner      =

I have carefully gone through the permissions on the object hierarchy and
can't find a reason for Zope to be requesting authorization.

The code works fine under Zope alpha 2. 

Even better this code works sometimes. It may have something to do with null
values in the DATA_PRECISION and DATA_SCALE columns (as I write this I don't
have access to the Oracle DB).

Any suggestions as to why this is happening would be most welcome.

Regards,
Neill Cox
-- 
+---------------------------------------------------------------------+
| Neill Cox                                                           |
| Ingenious Software Pty Ltd        Phone : +61 2 6258 4858           |
| 35 Carlile St                     Fax   : +61 2 6258 5737           |
| Evatt ACT 2617 AUSTRALIA                                            |
+---------------------------------------------------------------------+