WebDB LOV Error

From: <schmidm_at_kta95.com>
Date: 2000/06/26
Message-ID: <8j7j98$7r3$1_at_nnrp1.deja.com>#1/1


I have Oracle 8.1.6 and WebDB2.2 I am reading Oracle WebDB Bible.

While creating a report it gives instructions to add a specific report from a list (this is referring to an older version of WebDB). In version 2.2, I can type in the name of the table/view, or select the LOV button. When I pick the LOV button, I get the output below instead of a LOV.

Any ideas?
MS

POPUP LOV ERROR:
LOV: "select owner || '.' || object_name, owner || '.' || object_name from wwv_all_objects where object_type in ('TABLE','VIEW') and owner='NETU' union select owner || '.' || '<#SYNONYM#>'|| synonym_name, owner || '.' || '<#SYNONYM#>' || synonym_name from wwv_all_synonyms where owner='NETU' and db_link is null union select owner || '.' || table_name, owner || '.' || table_name from wwv_user_grants where grantee in ('NETU', 'PUBLIC') and privilege = 'SELECT'" Parse Message: Parse as invoker: "NETUDEV". Find Message: LOV is a SQL query.
wwv_parse.parse_as_user:WWV-08300 Failed to parse as NETUDEV - select owner || '.' || object_name, owner || '.' || object_name from wwv_all_objects where object_type in ('TABLE','VIEW') and owner='NETU' union select owner || '.' || '<#SYNONYM#>'|| synonym_name, owner || '.' || '<#SYNONYM#> wwv_parse.parse_as_user: ORA-00942: table or view does not exist

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jun 26 2000 - 00:00:00 CEST

Original text of this message