Re: Stored Proc Compilation Error

Hey Brian,

So you were able to take that code, place it into a stored procedure and compile it?

I double checked and that DATE is the name of the column. Here is the source table name definition.

CREATE TABLE HISTORY
(

  RECNUM         NUMBER(28)            NOT NULL,
  AP#            VARCHAR2(14 BYTE)     DEFAULT ' '    NOT NULL,
  CHANGED_FIELD  VARCHAR2(16 BYTE)     DEFAULT ' '    NOT NULL,
  PROGRAM        VARCHAR2(8 BYTE),
  DATA_BEFORE    VARCHAR2(30 BYTE),    DATA_AFTER     VARCHAR2(30
BYTE)              DEFAULT ' '    NOT NULL,


  "DATE"         DATE                  DEFAULT

TO_DATE('01/01/0001','MM/DD/YYYY') NOT NULL,
  HR             NUMBER(2)             DEFAULT 0      NOT NULL,
  MIN            NUMBER(2)             DEFAULT 0      NOT NULL,


  "BY"           VARCHAR2(25 BYTE),

  "COMMENT"      VARCHAR2(70 BYTE)

• Brent