SQL*Plus (MOSC)

MOSC Banner

prevent spooling from being stopped by spool off in secondary script being called

edited Dec 28, 2009 12:31AM in SQL*Plus (MOSC) 6 commentsAnswered
 I'm working on a table purge routine that is a sql script.  I start spooling a log at the beginning to check for errors.  In the middle of the routine I call another sql script that generates dynamic sql to rebuild the indexes on the table(s).  This routine spools a temp sql file to run.  The issue is this sub routine requires a spool off to do its thing.  Causing the spool logging in the main script to stop.

I'm looking for suggestions on how to best deal with this situation.  Thank you.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center