Re: sqlplus and here document

Are you certain this is the script that's running and that a different copy of it isn't being picked up by something in the PATH? It looks ok to me.

Have you tried combining the two here docs. IE just flow right from "spool off" to @ _xoit.sql.

From what I can see it *should* work. Nothing jumps out overtly as being wrong. What platform is this running on? Received on Fri Feb 24 2006 - 11:04:08 CST