315 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
2
replies
45
views
Spool failure that breaks up the excel due to few columns that contain paragraphs worth of data
So I have been tasked to automate numerous reports which i succeeded mostly apart from this one case, I tried many recommendations from chatgpt but most were busted, the broken excel file started ...
0
votes
0
answers
120
views
Splitting Spool by pages and download in ABAP
My customer has the request, that a spool with for example 10 Pages need to be downloaded by separated pages.
Let ́s say, that the Spool has 10 pages and at every two pages I need to split the Spool ...
0
votes
1
answer
45
views
SQLPlus Spool Issue
Simple problem. For audit purposes, a new set of steps was initiated when we sign into an Oracle DB using SQLPlus. At the first SQL> command prompt, we immediately activate spool to a file with a ...
0
votes
0
answers
47
views
Teradata Spool issue due to several union
I am wondering how to solve teradata query with several unions that causes spool issue.
let say.
single Query1 is executed and completes 11 seconds.
single Query2 is executed and completes 13 seconds.
...
0
votes
1
answer
59
views
Oracle SPOOL Not Returning Same Number of Rows
I have a simple SQL query which returns 21 rows of data when I run it in Toad.
However, when I SPOOL the results to a CSV, I always get less than 21 rows of data, e.g. 16 rows one run, then 10 rows ...
1
vote
1
answer
191
views
SQLPlus dynamic spool filename from Table in a FOR Loop
I am very new to Oracle Develop PL/SQL language (so please excuse limited understanding). I am trying to use a spool command to dynamically create a filename based upon a table row values.
Below is ...
0
votes
1
answer
475
views
Spool to pdf with CPYSPLF fails - CPFCE06 with reason code 8 - The transform interface detected a logic error
On one of iSeries machines (V7R5M0) I am creating PDF from spool file, like:
CPYSPLF FILE(QPJOBLOG) TOFILE(*TOSTMF) SPLNBR(*LAST) CRTDATE(*LAST) TOSTMF("/home/TE000667/test.pdf") WSCST(*PDF) ...
0
votes
1
answer
218
views
How to generate an output file directly into my local machine when running a spool script using Oracle sqldeveloper?
I am running a spool script using sqldeveloper. I have specified the path in my local to save the spool output file but its not saving. Also, in the sqldeveloper, the script output contains only the ...
-1
votes
2
answers
104
views
space in the export file Oracle SQL
i have 1 SQL file as below:
set pages 0
set head off
set feedback off
set echo off
set termout off
set wrap off
spool /osp/tmp/bangdd/dumpthe.dump
select a.SERNUM ||','|| b.AMOUNT||','|| b.TOPPF||','||...
0
votes
1
answer
103
views
Having Issue spooling data to CSV file
I am trying to spool data using the sql script shown below creating a file without data where it has 3 rows of data when ran select statement.
SPOOL "C:\Users\nmirza\Desktop\\YourFile.csv" ...
0
votes
2
answers
1k
views
I want to export oracle table into an Excel sheet side by side
I have few oracle tables and I want to fix them into a same excel sheet side by side using spool command.
Can I use cell reference inside spool command while trying to export those tables into a excel ...
1
vote
0
answers
115
views
sqlplus spool to csv will contain multiple header rows
I want to use sqlplus with spool to export about 14 million rows into '.csv' file.
I'm running the script on windows platform.
The script file looks like the following:
alter session set ...
0
votes
0
answers
74
views
How to Create folder from PLSQL command window using sql during spool
I have tried HOST MKDIR os command from my spool code and folder is not creating from windows location.
Please help.
Below are some snipper tried.
HOST MKDIR 'DDL'
HOST MKDIR DDL
HOST MKDIR &...
0
votes
0
answers
2k
views
Oracle sqlplus - Error: not spooling currently
Spool file is blank and getting error message "not spooling currently".
I am executing.
sql>set feedback on
sql>spool c:\test.log
sql>@c:\testscript.sql
sql&...
2
votes
0
answers
236
views
Oracle SQL predefined variable _CONNECT_IDENTIFIER not working with Spool in Toad
I am using Toad and have a file 'run_script.sql' that is used to run .sql scripts and spools to an output file. This has always worked for me, creating the spooled file in the same directory as the '...