Metacat

    INTO :new.entryid

    FROM dual;

END;

/* 

 * harvest_site_schedule -- table to store harvest sites and schedule info

  status                 NUMBER,         -- non-zero indicates an error status

  message                VARCHAR2(1000), -- text message for this log entry

  harvest_operation_code VARCHAR2(30),   -- the type of harvest operation

);

/* 

  error_message          VARCHAR2(1000), -- text error message

  document_type          VARCHAR2(100),  -- document type

  CONSTRAINT harvest_detail_log_pk PRIMARY KEY (detail_log_id),

        FOREIGN KEY (harvest_log_id) REFERENCES harvest_log

);