db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Nabbefeld <Peter.Nabbef...@gmx.de>
Subject Re: How to use stored procedures with triggers?
Date Sat, 04 Jun 2005 07:30:44 GMT
Satheesh Bandaram schrieb:
> Which version of Derby are you using? There was a known issue with using
> functions in values clause inside a trigger in 10.0 that got fixed in
> later versions.
> 
I'm using 10.0.2.1, as it is considered stable. My problem has probably 
been that I've not used 'MODE DB2SQL'. However, derby now complains 
about missing schema 'user', while I've prefixed everything with my own 
schema (seems to be ignored).

Kind regards

Peter Nabbefeld


> Satheesh
> 
> Peter Nabbefeld wrote:
> 
> 
>>In the thread mentioned before, I've been told to use a function in a
>>VALUES clause. So I've asked 'CREATE TRIGGER ... FOR EACH STATEMENT
>>VALUES(...) doesn't work. Will I really have to insert a dummy value
>>into some dummy table to call a procedure or function from a trigger? '
>>
>>Will I have to use 'DECLARE GLOBAL TEMPORARY TABLE ...'? And, as I
>>think autocommit is the default, will it be cleared automatically
>>after each INSERT? I'd prefer to have every inserted record deleted as
>>soon as possible, as it'd be used only as a dummy table, so memory
>>consumption should be as small as possible :-) .
>>
>>Kind regards
>>
>>Peter Nabbefeld
>>
>>
>>
> 
> 
> 


Mime
View raw message