long fields in trigger

"Jens Stier" <[email protected]> Tue, 9 Sep 2003 16:39:37 +0200
Newsgroups gmane.comp.db.sapdb.general
Message-ID <[email protected]>
Hi,


i have the following two tables:

CREATE TABLE "TBLARTIKEL"
(
	"ID"               Integer,
	"BEZEICHNUNG"               Varchar (50),
	"BILD"               Long BYTE
)


CREATE TABLE "TBLARTIKEL2"
(
	"BEZEICHNUNG"               Varchar (50),
	"BILD"               Long BYTE
)





now i want to create a trigger that inserts a new row to tblartikel2 each
time tblartikel is updated:

CREATE  TRIGGER artikelupdate FOR TBLARTIKEL AFTER UPDATE EXECUTE
(
INSERT INTO "DBA".ARTIKEL2(BEZEICHNUNG,BILD)
VALUES(:NEW.BEZEICHNUNG,:NEW.BILD);
)


if i don't save anything to the field "BILD" everything works fine. but if
anything is written to "BILD" I get the error message:
GENERAL ERROR;-3102



Is there any problem with long byte fields in triggers? how can i do this
then??



thanks


J