Re: spool

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 31 Oct 2001 11:12:18 -0000
Message-ID: <3bdfdcdc$0$238$ed9e5944@reading.news.pipex.net>

What are you trying to achieve?

SPOOL is a SQL*Plus command, not a SQL statement.

If you are trying to output text based on some program logic look into either dbms_output (to echo to the screen) or UTL_file to write to an OS file.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"Ctof" <ctof_at_worldonline.fr> wrote in message
news:3bdfd873$0$2298$626a54ce_at_news.free.fr...


> Hi,

> how can i use  the 'SPOOL' sql command in a PL/SQL file.

> the execution of spool depends on the value of a parameter... but i cant

> execute it in a begin - end structure...

> thanx

> C.

>

>

Received on Wed Oct 31 2001 - 05:12:18 CST