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
0
votes
1 answer
How to pass a query stored in a variable to a sql file. Shell script
I am creating a shell script where I have saved entries from a text file into an array. Those values are properly stored and show the correct contents. One of those entries contains a simple query and I want to pass it to a sql file. With that…
Alkey29
- 189
- 1
- 5
- 20
0
votes
1 answer
how to avoid .sql file from a folder
I am executing
#!/bin/bash
PARTITION_LOG=../log/auto_partition.log
PATH=../sql/
cd $PATH
SQL_FILES=`/bin/ls *.sql`
echo "$SQL_FILES"
for File in $SQL_FILES
do
if [ -f $File ]
then
f=$File
fi
$ORACLE_HOME/bin/sqlplus -silent…
Mayur Sawant
- 51
- 1
- 7
0
votes
0 answers
Every 16th call of swiftmailer:spool:send ends up with STMP timeout
I use file spool in my Symfony2.2 project. I flush spool every minut with cron.
An error occurs every 16 minutes with an accuracy of a few seconds: e.g. 14:38:31, 14:54:31, 15:14:31, 15:30:31. etc.
[12-Aug-2013 16:02:31 Europe/Berlin] PHP Fatal…
tiriana
- 668
- 1
- 7
- 24
0
votes
1 answer
Trying to use the Spool Command but no output file
I am trying to run a simple script just to see what might be the problem is. Seems like the spool command doesn't work and it doesn't create an output file though the select statement itself has no error.
Here's what I do. Saved a script in my c:…
memyme
- 1
- 1
- 2
0
votes
2 answers
Oracle SQL parallel spooling automatically
I have a heavy query which spools data into a csv file that is sent to users. I have manually made parallel sessions and am executing the query with filter condition so that i can join all spooled files at the end into one single file thus reducing…
mitrabhanu
- 389
- 1
- 2
- 13
0
votes
1 answer
How can I spool a csv formatted file using an SQL Command?
I have an SQL query that generates a result regarding the daily data from the database. I want a csv formatted file to be generated everyday with this query and saved in a folder. Is there any way I can do this?
NOTE: I am using SQL Server…
omar K
- 225
- 2
- 7
- 19
0
votes
1 answer
Spaces in the spool even with right set parameters
My spool has a problem; i've written these sets:
echo "SET COLSEP #@" >> ${FILE_SPOOL_SQL}
echo "SET PAGESIZE 0" >>…
Atlas91
- 5,754
- 17
- 69
- 141
0
votes
1 answer
spool text file content wrapping unexpectedly
I generated a dynamic spool text and stored them in a table. I then use File A to spool the text to create dynamic_spool_script.sql. In dynamic_spool_script.sql, there is unexpected wrapping between the 50th and 60th characters at random lines…
user393624
- 11
- 3
0
votes
1 answer
Getting IPAddress with XcvData
I am needing to get the ip of the printer but am not having much success.
Already tried in various ways. Currently my code is like this:
void Spl::GetIpAddress(LPSTR printerName)
{
HANDLE hPrinter;
PBYTE wAddress = NULL;
DWORD…
msantiago
- 346
- 2
- 4
- 14
0
votes
1 answer
Getting intermediate spool output
Am using oracle 11g, and i have a sql file with 'spool on' which runs for at least 7+ hours, as it has to spool huge data. But spool output is dumped only when the whole sql is finished, but i would like to know is there any other way to know the…
SPK
- 11
- 2
0
votes
2 answers
Any possible way to save output of sqlplus command into an array - Perl
Currently, I am spooling the sqlplus command into a text file but even this is causing me problems as I would like to separate the values by commas. So far It has not worked.
I was hoping something like this would work
@test = system('sqlplus…
James Mclaren
- 666
- 4
- 10
- 25
0
votes
6 answers
oracle spool query
I have written the sql by name cashload.txt on unix box and kept it on the following location on unix box:
exit |sqlplus -s batch/password@SW_TEST @/soft/checkfree/AccurateBXG/scripts/cashload.txt
In the cashload.txt the below code is…
kunj
0
votes
1 answer
How can I set up a SPOOL script in Oracle APEX to export view data as a CSV?
I have a view in APEX which I want to export to the drive as a CSV file (which would be picked up by processes from other applications). There is the UTIL_FILE method but it seems much more complex. How can I use SPOOL to export a view as a CSV? I…
antonpug
- 13,724
- 28
- 88
- 129
-1
votes
1 answer
Question about Spanning Column and Rows in Spool in SQL-Developer
Is it possible to colspan and rowspan when spooling into a .xls file?
like using a colspan and rowspan in html
Alec Lucero
- 3
- 2
-1
votes
1 answer
How To Spool Spanish Characters Using sqlplus?
I want to spool spanish characters in a text files.
The spanish characters are stored in oracle database but while spooling it interprets the spanish characters. I have changed the NLS_LANG to spanish but nothing works for me.
Please help how can I…
ANCHAL BHASIN
- 13
- 5