Identity Column and stored procedure in Oracle Help

From: Lakshmi <lakshmiysr_at_yahoo.com>
Date: 21 Oct 2002 11:18:54 -0700
Message-ID: <d7821b44.0210211018.8700_at_posting.google.com>


I am new to Oracle…Please can anyone help

I have migrated my data from Microsoft SQL to Oracle. On migration the tool created a trigger for the identity column. Now I get an error ‘not enough values' in my stored procedure INSERT INTO sa.Alertlog VALUES (SP_ALERT_SP.alertNum);

Table: Alertlog
Fields: alertlognum(identity column), alertNum

Trigger: TR_S_2536_Alertlog

BEGIN
  SELECT sa.S_2536_ALERTLOG.nextval
  INTO omwb_emulation.globalPkg.identity   FROM dual;
  :new.ALERTLOGNUM:=omwb_emulation.globalPkg.identity;  END; Received on Mon Oct 21 2002 - 20:18:54 CEST

Original text of this message