Re: Stored Proc Compilation Error

On 19 Oct 2004 06:34:45 -0700, dc wrote:

>  	INSERT INTO R_HISTORY


> 	(

> 	AP#,

> 	DATA_BEFORE,

> 	DATA_AFTER,

> 	HISTORY_DATE

> 	)

> 	SELECT

> 	AP#,

> 	DATA_BEFORE,

> 	DATA_AFTER,

> 	"DATE"

>  	FROM mf.HISTORY;

It works for me. Make sure "DATE" is really the correct spelling for the
column in the history table. By double quoting the column you are making it
case sensitive.