Am Sonntag, 17. August 2003 17:18 schrieb Uwe Haussmann: > Hallo, > > I am having a problem defining a procedure for a table which has a > LONG column. > > When trying to create the proc, I get the error: > Syntax error or access violation;-5015 POS(228) Missing > keyword:VARCHAR,TIMESTAMP,TIME,SMALLINT,REAL,NUMERIC,INTEGER,. > > What's wrong ? > > > CREATE DBPROC pr_Ereignisse_ins > ( > > OUT ItemID int, > IN ModuleID int, > IN AppId smallint, > IN Sprache char(2), > IN Ersteller varchar(50), > IN Datum timestamp, > IN Titel varchar(150), > IN Ereignis varchar(150), > IN Beschreibung Long, ^^^^^^^^^^^^^^^^^^^
as far as i know, LONGs are not allowed in TRIGGER/DBPROCs - see error message above. > IN Ablauf Timestamp > ) best regards Matthias Griem _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
