The name of the script file is oii_log.sql. After the execution of an import job, the software will query the protocol table and spool the results out to a file. Formatting commands are suited for printout in DIN A4 landscape format or DIN A3 portrait format. You can alter any of the formatting commands, but you should not modify the script parameters.
REM -----------------------------------------------------------
REM Smart Materials
REM -----------------------------------------------------------
REM
REM File: OII_LOG.SQL
REM OII Import Protocol for last import,
REM will be called immediately after import
REM main procedure has finished
REM Author: PSchneider, UBH
REM Created: 27-FEB-1998
REM Changed: 30-Jan-2001, NR, Exchanged copyright information
REM -----------------------------------------------------------
REM
REM
REM Parameters for script call are:
REM
REM &1: oij_id m_oii_import_jobs.oij_id%TYPE -> NUMBER(12)
REM &2: proj_id m_projects.proj_id%TYPE -> VARCHAR2(10)
REM &3: Fully qualified name for spoolfile
REM
WHENEVER SQLERROR EXIT FAILURE
WHENEVER OSERROR EXIT FAILURE
SET TIMING OFF
SET FEEDBACK OFF
SET LINESIZE 500
SET TRIMSPOOL ON
SET PAGESIZE 66
SET ARRAYSIZE 1
SET VERIFY OFF
SPOOL &3
PROMPT
PROMPT
PROMPT ************************
PROMPT * *
PROMPT * Smart Materials *
PROMPT * *
PROMPT ************************
PROMPT
PROMPT Open Ident Interface - Import protocol
PROMPT
PROMPT Copyright (c) 2001, Intergraph CorporationPROMPT
PROMPT
PROMPT Call parameters:
PROMPT
PROMPT OII Job ID: &1
PROMPT Project: &2
PROMPT Spoolfile: &3
PROMPT
PROMPT
COLUMN err_line_number HEADING Line# FORMAT 9999999
COLUMN state HEADING ST FORMAT a2
COLUMN kind HEADING Kind FORMAT a12
COLUMN msg_text HEADING Text FORMAT a50 WORD_WRAPPED
COLUMN rec_type HEADING Type FORMAT a11
COLUMN f1 HEADING F-1 FORMAT a20 TRUNCATED
COLUMN f2 HEADING F-2 FORMAT a20 TRUNCATED
COLUMN f3 HEADING F-3 FORMAT a20 TRUNCATED
COLUMN f4 HEADING F-4 FORMAT a20 TRUNCATED
SET TERMOUT OFF
SELECT oije.err_line_number,
oije.state,
oije.kind,
oije.msg_text,
oid.rec_type,
oid.f1,
oid.f2,
oid.f3,
oid.f4
FROM m_oii_import_data oid,
m_oii_import_job_errors oije
WHERE oije.oij_id = &1
AND oije.proj_id = '&2'
AND oije.oid_id = oid.oid_id (+)
AND oije.proj_id = oid.proj_id (+)
ORDER BY oije.oije_id;
SET TERMOUT ON
PROMPT
PROMPT
PROMPT OII Import protocol done.
PROMPT
SPOOL OFF
EXIT