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

The 'AND' in the fourth line of the script was a mistake... I removed it but it still gives me the same error.

swethasiva..._at_gmail.com wrote:
> 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:19:39 CDT