Bill I meantt to post this last friday, you probably have someting
working by now, but here is what I use, simple but effective ;-)
spool C:\work\test_links\tlink.sql
set feedback on
set echo on
set pagesize 0
set linesize 450
SELECT 'select * from dual@(protected)) ||
'COMMIT;'||chr(10)||
'ALTER SESSION CLOSE DATABASE LINK '||db_link||';'
FROM dba_db_links
order by 1;
spool off
@C:\work\test_links\tlink.sql
hth
Bob
--
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."
--
http://www.freelists.org/webpage/oracle-l