Re: WebDB and database link

I'm not sure how well WebDb handles DB Links, but you can create a view with your select statement and base the report on that view...That does work..

Hope it Helps,
John Greco

"Klaus Zeuch" <Klaus.Zeuch_at_erls04.siemens.de> wrote:

>Hi,
>
>I'm running WebDB 2.1.0.9.3 on Windows NT with Oracle 8.0.5 on NT (for test
>purposes; production environment HP-UX). Within the NT database I created a
>public database link pointing to an Oracle 8.0.5-Instance on HP-UX.
>When building a report from sql query with query
>SELECT * FROM remote_schema.remote_table_at_dblink_name
>I'm always running into ORA-03113 error (end of communication channel)
>during execution of WEBDB.wwv_builder.accept - but both nt-ora8 instance
>and HP-UX ora8 instance are working and I can connect via SQL*Plus.
>
>The statement works fine in SQL*Plus being connected as user where the
>webdb_package will (should) be created.
>
>Does WebDB support database links?
>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Fri Dec 17 1999 - 20:13:08 CET