DBPROC - Problem with LONG column definition

Uwe Haussmann <[email protected]>
Newsgroups gmane.comp.db.sapdb.general
Organization Haussmann IT Consulting
Message-ID <[email protected]>
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,
        IN Ablauf Timestamp
)
        As
        
                TRY     
                INSERT
                INTO PT.Ereignisse
                (
                ModuleID,
                AppId,
                Sprache,
                Ersteller,
                Datum,
                Titel,
                Ereignis,
                Beschreibung,
                Ablauf
        )
        VALUES
        (
                :ModuleID,
                :AppId,
                :Sprache,
                :Ersteller,
                :Datum,
                :Titel,
                :Ereignis,
                :Beschreibung,
                :Ablauf
        );

                SET ItemID = PT.Ereignisse.CURRVAL ;

        CATCH
                 IF $RC <> 100 THEN STOP ($RC,'Fehler');


  Appreciate help, thx
 

-- 
mit freundlichen GrÌßen,
 Uwe Haussmann                          mailto:[email protected]
 PGP Public Key at http://www.webdevelopers.de/pgp.txt
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.