I'm building a Delphi interface to let my customers create a mailing list instead of asking me to do it. When I put the sql into a TOracleQuery, though, it can't get past the spool command to create the desired file name. What would you suggest? The sql works fine in PL/SQL Developer.

The spool command is not a SQL command, so it cannot directly be used for the TOracleQuery component. You will have to create a Delphi function to process the query results and write them to a file.

Okay, thanks Marco.