WebDB Reports from SQL Query

From: Klaus Zeuch <Klaus.Zeuch_at_erls04.siemens.de>
Date: 2000/04/27
Message-ID: <8e9emk$suu$1_at_papyrus.erlm.siemens.de>#1/1


Hi,

I have problems with webdb 2.1 on 8.1.5 (hp-ux 64 bit) when creating / modifying reports based on longer sql-statements (no carriage returns or other formatting efforts in the statements). Sometimes my sql-code is simply replaced with the default-statement (id 12022 in wwv_sys_builder_details). Any ideas what causes this nasty behaviour?

I also tried to simply update the value-column in WEBDB.WWV_MODULE_DETAILS$ for attribute_id 12023 (= the statement; referenced tables (= id 12021) were o.k.); result: Report definition can't be edited via webdb any more

Best regards,

Klaus Received on Thu Apr 27 2000 - 00:00:00 CEST

Original text of this message