Re: WebDB and database link

WebDB supports DBlinks, but I too have had problems with ORA-03113 (end of com...). I've tried using views with some degree of success, but I got a couple of views that return ORA-03113 (select count(*) from v_<view-name>; --> ORA-03113 :-(

Is there anybody out there that can shed some light on this ?

Lasse from Norway

TurkBear skrev i meldingen <385a8afd.16657171_at_super.news-ituk.to>...
>
>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 24 1999 - 12:58:27 CET