WebDB LOV Error
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