Problem solve
Get help with specific problems with your technologies, process and projects.
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"?
Can I spool only errors in SQL*Plus when creating procedures and functions and not spool successful messages such as "Procedure created. No errors"?
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.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments