Hi Everyone,
I have a view made up of a local query unioned with
a view comprised of a dblink query.
If the dblink query cannot establish a connection,
I get the "could not connect to server" error and the whole view
fails.
Setting fail_on_error to false does not
work in this situation.
Is there any way to test the connection inside the
view when the view is called and either return the whole view or just the
local component if a dblink connection cannot be made?
Thanks,
George
|