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

>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';

This query gives me 'no data found' when I execute it from the user in whose schema I try to create the trigger.

Maxim Demenko wrote:
> 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:48:09 CDT