Problem while using HTML Schema Doc Generator

Toad for Oracle
1

Hello,

I would like to give access to a standard Oracle user the access to the HTML Schema Doc Generator function.

I have granted it the "SELECT ANY DICTIONARY" privilege which I believe should be sufficient but I get the following error upon generating the report:
ORA-00907: missing right parenthesis

Would you have an idea?

Best regards,
Julien

2

Hi Julien,

On the main menu, click Database -> Spool SQL -> Spool to screen. This will capture all SQL that Toad runs and display it at the bottom of Toad.

Then run the schema doc again. Grab the SQL that's causing the ORA-00907 (It'll probably be the last one), and post it here.

Also, let us know which version of Toad you have, and which version of Oracle you are using it with.

Thanks

John

3

Hello John,

This the the output of the spool:

-- Session: xxx@SID.WORLD
-- Timestamp: 13:36:19.607
Select o.object_type, pp.*
from sys.dba_objects o,
(Select p.grantee, p.owner, p.table_name, p.privilege, p.grantable, p.hierarchy
from sys.dba_tab_privs p
where p.grantee = :own
and not ((length(p.table_name) = 30) and
(substr(p.table_name, 1, 4) = 'BIN$') and
(substr(p.table_name, 27, 4) = '==$0'))
ORDER BY 1, 2, 3, 4, 5;
:own(VARCHAR[9],IN)='SCHEMA'

-- Session: xxx@SID.WORLD
-- Timestamp: 13:36:19.607
Select o.object_type, pp.*
from sys.dba_objects o,
(Select p.grantee, p.owner, p.table_name, p.privilege, p.grantable, p.hierarchy
from sys.dba_tab_privs p
where p.grantee = :own
and not ((length(p.table_name) = 30) and
(substr(p.table_name, 1, 4) = 'BIN$') and
(substr(p.table_name, 27, 4) = '==$0'))
ORDER BY 1, 2, 3, 4, 5
Error: ORA-00907: missing right parenthesis

We-re running pretty old versions unfortunately, Oracle is 11.2.0.2.0 and Toad is 13.1.1.5

I have already downloaded the latest version of Toad and I intend to try it as soon as possible

Best regards,
Julien

4

Hi Julien,

This error sounds familiar. I believe it was fixed some versions ago. Let me know if you still have a problem in Toad 15.1. You could avoid the error in 13.1 by unchecking the option(s) in html schema doc to include grants.

-John

5

Hi John,

I confirm that this works with the workaround on the old version.

Also no problem with the latest version.

Thanks for your help,
Julien

1 Like