CODEWITHSUNDEEP
oracle-databasefilesqlplusspool
kasaoole
kasaoole

Reputation: 11

Opening a SQL plus spool file dynamically (before spool off)

The screen reader tool (JAWS/CURSOR) for the blind, fails to read the results of a SQL statement in Oracle SQLplus. Spooling the output and having the spool file read in a text editor is working fine. But it is tedious to turn off the spool after every SQL statement to ascertain the results. Does anyone know a way of opening a spool file without turning off the spooling (without spool off) Thanks

Upvotes: 1

Views: 2570

Answers (1)

Alex Poole
Alex Poole

Reputation: 191570

Oracle buffers output to the spool file and flushes it periodically (every 8KB on my system, and I can't see a way to adjust that; according to Tom it's the O/S that actually does that), but doesn't do a final flush until you close the file (so if you run a query that produces a lot of output you can see partial results in the spool file, but the end is missing; at least in *nix). You therefore can't usefully look at the file until you close it with spool off.

In a Unix/Linux environment I'd suggest using sqlplus | tee <file>, which mirrors the entire session into a file and doesn't have the buffer delay. There seem to be Windows equivalents for tee, but I have no experience with them.

I wonder if you're restricted to SQL*Plus though. Have you looked at using SQL Developer instead? Again I have no experience of using this with a screen reader, but they at least seem to have thought about it.

Upvotes: 1

Related Questions