Trigger to insert random number into Oracle 10g table

Hello all

I am using Oracle 10g Express Edition and I wish to create a trigger to insert a random number into a table.

The following script gives me a compile time error:

create or replace trigger beforeinsert_randnumber before insert
on someTable
referencing NEW as New and OLD as Old
for each row
begin

    select TO_NUMBER(SUBSTR(dbms_crypto.randominteger, 2, 8)) into :New.RandNumber from DUAL;
end;

Could someone please suggest what might be wrong in this script?

Thanks
Swetha Received on Thu Oct 05 2006 - 04:44:36 CDT