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

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

What is the result of this query for you (meant for user in those schema you try to create the trigger) ?

SELECT * FROM user_tab_privs WHERE table_name = 'DBMS_CRYPTO';

Best regards

Maxim Received on Thu Oct 05 2006 - 05:33:18 CDT