Re: Trigger to insert random number into Oracle 10g table

swethasivaram_at_gmail.com wrote:
> 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?
>

What IS the compile time error you get?

Also, why not try:
:New.RandNumber := TO_NUMBER(SUBSTR(dbms_crypto.randominteger, 2, 8));

cheers,
Martin Received on Thu Oct 05 2006 - 04:59:36 CDT