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 ?!

Nicola wrote:

If you are a member of the Oracle community ... and that appears to be
the case ... please demonstrate courtesy to us by not cross-posting and
posting in the appropriate usenet group: That means
comp.databases.oracle.marketplace.

I will NOT purchase any of your books, nor will I encourage my summer
students to do so, until you apologize and promise to not cross-post and
not spam again.

Thank you.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Daniel Morgan <damorgan (AT) exxesolutions (DOT) com> wrote

<snipped>

Er.. Daniel? Can I please now have my lead pipe back?

;-)
--
Billy