Dynamic spool file in SQL*Plus ?

From: Jarek Palka <jpalka_at_interia.KILLSPAM.pl>
Date: Tue, 26 Feb 2002 14:45:51 +0100
Message-ID: <3C7B918F.3060408@interia.KILLSPAM.pl>

Is it possible to set spool filename dynamic based on return value of SELECT statement ?

I'd like to set spool filename the same as username to which I'm connecting:

Such statement don't work :-((

SELECT substr(user,1,8)||'.txt' INTO :uname FROM DUAL; SPOOL :uname
-- script body

SPOOL off
--

---

Jaroslaw Palka <jpalka_at_interia.KILLSPAM.pl> Katowice POLAND <Remove KILLSPAM from address > Received on Tue Feb 26 2002 - 07:45:51 CST