howto Lite Stored Procedure assigning sequence Java
From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: Fri, 22 Jun 2001 19:16:26 GMT
Message-ID: <eQMY6.7087$CP2.1323270_at_afrodite.telenet-ops.be>
END;
/
Date: Fri, 22 Jun 2001 19:16:26 GMT
Message-ID: <eQMY6.7087$CP2.1323270_at_afrodite.telenet-ops.be>
I'm a newbie to Oracle Lite and Java.
[Quoted] I would like to create a stored procedure on a lite database just assigning
the next value of a sequence to an id in a table
( In PL/SQL this would look like:
CREATE OR REPLACE TRIGGER my_assign_id
BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
SELECT my.nextval
INTO :NEW.id
FROM sys.dual;
END;
/
Can anyone give me the java code and instructions to do the same on a lite
database?
Many thanks.
Received on Fri Jun 22 2001 - 21:16:26 CEST