SQL> ed
Wrote file afiedt.buf

  1  declare
  2   v_code number;
  3   v_errm varchar2(512);
  4  begin
  5   execute immediate 'CREATE OR REPLACE VIEW v_xxx as select * from eemp';
  6  exception when others then
  7   v_code := SQLCODE;
  8   v_errm := SQLERRM; 
  9   dbms_output.put_line('Ошибка: '||v_errm);
 10* end;
SQL> /
Ошибка: ORA-00942: table or view does not exist

PL/SQL procedure successfully completed.