writing output to a file from a procedure in sqlplus - SPOOL

Vote count:

0

Due to being unable to use UTL_FILE (lack of privileges, changing that not gonna happen :/) I'm messing with using SPOOL to get output from my procedure to a CSV file. I'm trying to wrap this in an sql file. The part I'm having problems with:

spool output.csv / DECLARE ... BEGIN ... END; / spool off quit /

Problem is, this way the whole block lands in my output file, followed by the output, while I would like just the output. Any workarounds ?

asked 1 min ago

aPinchOfInsomnia

20

writing output to a file from a procedure in sqlplus - SPOOL