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