Re: DBPROC - Problem with LONG column definition

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