Outputting errors when executing SQL scripts in Sqlplus

Question

I have a number of huge .SQL files that inserts data into tables. I'm using Sqlplus to execute these scripts. While the command window is crunching all these thousands of INSERT INTO {table} statements, I occasionally see an error showing up in the command window for a split second before Sqlplus goes on to the next INSERT INTO {table} statement.

Is there a way to show any error that comes up after executing a SQL script in Sqlplus?

Took a look at spool-ing, put it in my SQL script and it worked like a charm. Thanks. — Gunnar
– Gunnar, Commented Jul 29, 2015 at 16:56

Baski · Accepted Answer · 2015-07-29 15:41:29Z

1

Apart from spooling you could use error logging feature with DML. This link gives you details enter link description here

answered Jul 29, 2015 at 15:41

Baski

8398 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gunnar Over a year ago

SPOOL was exactly what I needed. Thanks.

Collectives™ on Stack Overflow

Outputting errors when executing SQL scripts in Sqlplus

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related