SQL Language (MOSC)

MOSC Banner

Oracle sql statement should not be displayed when errors out

edited Oct 16, 2019 12:29PM in SQL Language (MOSC) 8 commentsAnswered ✓

Oracle sql statement should not be displayed when errors out.

select abc from dual;

select abc from dual

       *

ERROR at line 1:

ORA-00904: "ABC": invalid identifier

I do not want below to be displayed when errors out, just ORA- error should be displayed.

select abc from dual

       *

I tried verify off, echo off, termout off , autop off head off.   how can we restrict oracle sql display when it errors out.

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