SPOOL is an acronym for simultaneous peripheral operations on-line. It is a type of buffering. The most common spooling application is print spooling, which places a task (or 'print job') into a queue for extended or later processing.
Questions tagged [spool]
310 questions
2
votes
1 answer
Oracle Spool adds extra LF
I have a Spool of a Select as :
SET SERVEROUTPUT ON
WHENEVER SQLERROR EXIT 1
set heading off
set feedback off
set termout off
set echo off
set verify off
set pagesize 0
set line 1000
set trimspool on
spool &1
SELECT '9' || 'c' || chr(10) ||…
CC.
- 2,736
- 11
- 53
- 70
2
votes
3 answers
Oracle plsql switch case and sqlplus spool
The following query runs in an error at the THAN statement. Is it possible to use a select in the THAN statement? Any ideas on how to make it work?
SET SERVEROUTPUT ON
SET TERMOUT OFF
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 140
SET PAGESIZE…
r0tt
- 379
- 3
- 20
2
votes
1 answer
Send emails via memory in controllers and spool in some commands in Symfony2
I need to use the spool option to send massive emails to my users, but i won't to change whole config of my app to spool because my register system send an email to the user and i want that this email be instant send.
Is any way to do this without…
Borja Pombo
- 525
- 1
- 7
- 30
2
votes
0 answers
Spooling Japanese data from oracle Database
I am trying to spool data from database, the data consists of Japanese characters.
Please find the below code that is used for spooling data.
set echo off
set verify off
set heading off
set termout off
set feedback off
set pages 0
set linesize…
vakul
- 157
- 3
- 17
2
votes
1 answer
Does anyone know how to read gzip file(gzip in thr spoolSourceDirectory) in Flume process?
If we want to get data from spoolDir which contains Gzip file in it, what should I change for the source in the Flume process? Just have a customized EventDeserializer or also need new source type(eg., a customized GzipSpoolDirectorySource instead…
user3502577
- 99
- 2
- 7
2
votes
2 answers
SPOOL command doesnt save result in query
I'm using SQL Developer and I'm trying to save result of a query into the text file using spool command.
spool D:\file.txt
SELECT * FROM TABLE
SPOOL OFF
When I open created file it only has my query in it:
"SELECT * FROM TABLE"
but not result of…
matip
- 794
- 3
- 7
- 27
2
votes
0 answers
Send PDF file to spool get stuck printing
I did the following code to read a PDF file from disk and send it to a print spool.
public boolean sendToSpool(File pdf, int copies) {
InputStream is;
try {
is = new FileInputStream(pdf);
} catch…
leocborges
- 4,799
- 5
- 32
- 38
2
votes
0 answers
Can you create your own spool in symfony 2?
I'm trying to log stats after my response has been sent in Symfony 2.
I'm using the kernel.terminate event but I can't use the session from it because headers have been sent.
So I'd like to use a spool to do like SwiftMailer but with stats.
Do you…
MortisQc
- 154
- 1
- 9
2
votes
4 answers
Remove leading spaces and the SQL> tags when spooling
I m doing an export using SQL*Plus using the following code:
Set echo off
Set verify off
Set feedback off
Set heading off
Set termout on
Set pages 50000
Set linesize 1000
Set newpage none
Set colsep ","
spool Z:\ff\ss.csv
Select Client_ID, Cust_ID…
Keithx
- 2,994
- 15
- 42
- 71
2
votes
7 answers
oracle sql plus spool
I'm using sql plus to execute a query (a select) and dump the result into a file, using spool option.
I have about 14 millions lines, and it takes about 12 minutes to do the dump.
I was wondering if there is something to make the dump faster?
Here…
CC.
- 2,736
- 11
- 53
- 70
2
votes
2 answers
How to get page count of spl file
I'm working on a project that aims at monitoring print jobs. I'm copying spl and shd files from spool folder to a temporary folder and trying to parse the to get data I want such as number of printed pages, owner, date and time...
I'm using the…
user2327385
- 21
- 3
2
votes
1 answer
coldfusion - cfprint issues with large spool files
I am using cfprint from ColdFusion to print multiple PDFs from a directory. The problem I am having is that when the files are spooled to the printer the size of the file dramatically increases and slows down everything. The file in the folder is…
DRG
- 21
- 1
2
votes
2 answers
Using Spool in Oracle 11g
I want to use spool functionality in Oracle 11g.
I want the entire output to be spooled into a file and a subset of the output to be spooled into a separate file.
In the below example I want temp_1.txt to contain data from A,B,C,D and E
In…
user1918858
- 1,202
- 1
- 20
- 29
2
votes
1 answer
Swiftmailer doesn't send email (only store in spool)
I have a web application made with Symfony 2.4 and I use SwiftMailer to send emails.
I use like mailer transport sendmail.
When user send an email, I don't receive this email. But If I do in command line:
$php app/console swiftmailer:spool:send…
user2794692
- 361
- 2
- 10
- 24
2
votes
2 answers
Oracle: How can I concatenate a substitution variable to form part of the filename?
I have a script that contains many stand alone blocks of SQL. I employ a substitution variable in the WHERE clause of each SQL block.
For Example:
DEFINE regionValue="Townsville Region" --yes, there is a space in the attribute value.
Select…
Tony
- 59
- 1
- 5