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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
