Register Login

Trigger Created with Compilation Errors

Updated May 18, 2018

Hi all ;
I have tried to find DB details using trigger. but i did not get any output amd also i am getting Trigger created with compilation errors.
SQL> create trigger  trigger_db_hist                       
  2  AFTER STARTUP ON DATABASE
  3  begin
  4  insert into db_hist(ins_no , ins_name , dbid , db_name , startup) values
  5  (INSTANCE_NUMBER ,INSTANCE_NUMBER , DBID , NAME , STARTUP_TIME);
  6  end;
  7  /
Warning: Trigger created with compilation errors.
SQL> startup
ORACLE instance started.
Total System Global Area  285212672 bytes
Fixed Size                  1267068 bytes
Variable Size             104860292 bytes
Database Buffers          176160768 bytes
Redo Buffers                2924544 bytes
Database mounted.
Database opened.

SQL> select * from db_hist;
no rows selected


×