OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Problem with calling dbproc in the trigger

From: Andrzej Ka¼mierkiewicz (kazikremedium.com.pl)
Date: Tue Aug 30 2005 - 11:54:58 CDT

Hello,

I'm using SapDb 7.4.3.31 under Win2000(SP4).

I have a table and on insert trigger for it.
Trigger only call some DbProcedure:
CREATE TABLE A ("TXT" Varchar (100) ASCII)
//
CREATE DBPROC TEST AS
    VAR x Integer;
SET x=0;
//
CREATE TRIGGER A_INSERT FOR A AFTER INSERT EXECUTE
(
    CALL ADMIN.TEST;
)

When I try to insert row in to this table:
INSERT A SET TXT='Test1'
my insert statement is executed witout error but there is no new row in
the table.

When I change the trigger:
DROP TRIGGER A_INSERT OF A
//
CREATE TRIGGER A_INSERT FOR A AFTER INSERT EXECUTE
(
    CALL ADMIN.TEST;
    SELECT NOW() FROM ADMIN.DUAL; /* some insert, update, delete, select
statement */
)
and when I execute my insert again everything is OK.

Is it bug, or am I doing something wrong?

Thank for your help and support.
Andrzej Ka¼mierkiewicz
REMEDIUM

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb