Problem using TIME datatype in dbproc

Fri, 07 Oct 2005 09:36:44 -0700 

Why does this return "Integrity constraint violation;-8006 POS(1) Data types
must be compatible"? The field in rectbl is a TIME datatype.

CREATE DBPROC SP_UPDATE_TIME(
        IN REC_ID FIXED (10,0), 
        IN UPDTIME TIME
) 
AS UPDATE MYDB.RECTBL SET UPDTIME = :UPDTIME WHERE REC_ID = :REC_ID;

Thanks for the help.


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to