Open
Description
After set feedback to off all error logs raised in PL/SQL code are suppressed since sqlcl version 24.3.
SET FEEDBACK OFF;
BEGIN
raise_application_error (-20000, 'Test error');
END;
/
For this code we don't get "Test error" on screen.
For select:
SET FEEDBACK OFF;
select count(*) from not_existing_table;
we get error:
Error starting at line : 1 in command -
select count(*) from not_existing_table
Error at Command Line : 1 Column : 22
Error report -
SQL Error: ORA-00942: table or view does not exist
https://docs.oracle.com/error-help/db/ora-00942/00942. 00000 - "table or view%s does not exist"
*Cause: The specified table or view did not exist, or a synonym
pointed to a table or view that did not exist.
To find existing user tables and views, query the
ALL_TABLES and ALL_VIEWS data dictionary views. Certain
privileges may be required to access the table. If an
application returned this message, then the table that the
application tried to access did not exist in the database, or
the application did not have access to it.
*Action: Check each of the following
- The spelling of the table or view name is correct.
- The referenced table or view name does exist.
- The synonym points to an existing table or view.
More Details :
https://docs.oracle.com/error-help/db/ora-00942/
But if this select is inside PL/SQL block:
SET FEEDBACK OFF;
declare
vi_count PLS_INTEGER;
begin
select count(*) into vi_count from not_existing_table;
end;
/
once again we don't get any error log.
Metadata
Metadata
Assignees
Labels
No labels