Spooling true error messages only

Can I spool only errors in SQL*Plus when creating procedures and functions and not spool successful messages such as "Procedure created. No errors"?

    Requires Free Membership to View

Sorry, but this cannot be done, at least not natively in SQL*Plus. You can spool the output to a text file and then write a parser (using Perl or other) to parse the output. That is about the best you can do.

This was first published in August 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.