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

Martin T. wrote:
> What IS the compile time error you get?

PL-SQL: ORA-00904:: invalid identifier

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

This gives me another error:
PLS-00201: identifier 'DBMS_CRYPTO' must be declared Received on Thu Oct 05 2006 - 05:14:33 CDT