Re: RE: strange data format error: ora-01821

2002-08-28 Thread zhu chao
DENNIS WILLIAMS, hi, thanks for your answer. First i appolygize for input so much data in the mail. As i said,the query runs well in sql*plus.But in OWB(Oracle WareHouseBuilder, it just refused to work. As i posted in the trace file: >*** SESSION ID:(8.21) 2002-08-28 12:

RE: strange data format error: ora-01821

2002-08-28 Thread DENNIS WILLIAMS
Zhu - I compliment you on your preparation. You have avoided the normal pitfall and posted a great deal of information about your issue, which I hope will allow one of the experts on the list to diagnose your problem. The query you post is "select 1 from dual@dblink". Is this really the ex