you can't spool from PL/SQL -- that's a SQL*Plus command. UTL_FILE is the way to go.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote