java, trigger and sequence

From: Nicola <nicola_at_retre.it>
Date: Sat, 19 Jul 2003 09:28:29 GMT
Message-ID: <1b8Sa.54161$it4.1409832@news1.tin.it>

I have to create a trigger that, using java class, calculates a barcode (EAN13) ena having in input a number from an autoincrement object (sequence ?). This is my incomplete code.

CREATE AND COMPILE JAVA SOURCE NAMED "EAN13" AS import java.lang.*;
public class EAN13 {

       public static void getBarcode (String code){ ............ } }
CREATE PROCEDURE PROCEAN13(code VARCHAR2)

        AS LANGUAGE JAVA
        NAME 'EAN13.getBarcode(java.lang.String)';
CREATE TRIGGER TRG_EAN13
        BEFORE INSERT OR UPDATE OF barcode ON prova
        FOR EACH ROW CALL PROCEAN13(:new.barcode)

CREATE TABLE prova ( barcode char(13), name ( VARCHAR(40)) I don't know how to get in input to PROCEAN13 a sequence value. I try to limit code to example written on top of this page but when I try to create TRIGGER oracle says: columns is an invalid column !

Please help me ?! Received on Sat Jul 19 2003 - 04:28:29 CDT