[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_60

Title:Oracle Rdb - Still a strategic database for DEC on Alpha AXP!
Notice:RDB_60 is archived, please use RDB_70..
Moderator:NOVA::SMITHISON
Created:Fri Mar 18 1994
Last Modified:Fri May 30 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:5118
Total number of notes:28246

4960.0. "Use of Oracle7 functions causes RDMS-E-RTNUSENOTALL" by NOMAHS::SECRIST (Rdb WWS; [email protected]) Fri Jan 24 1997 13:24

    
    [Rdb 7.0]  Customer is using Oracle7 SQL functions having executed
    @sys$library:sql_functions70.sql and committed.  The following
    simple example works on their development system but not their
    production system from interactive SQL:
    
    SQL> declare :x integer;     
    SQL> begin set :x = abs(-1); end;
    
    Development system dies with RDB-E-EXTRUN_FAIL followed by
    RDMS-E-RTNUSENOTALL "too many privileges available."  Any
    ideas ?  The names of the installed *SQL*, *RDM*, and *RDB* 
    images are the same (with the exception of SQLSRV$PRVSHR on
    production, but this isn't an Sql/Services issue).
    
    Any idea ?
    
    Regards,
    rcs
T.RTitleUserPersonal
Name		DateLines
4960.1In an active session with a deleted UAF entry !NOMAHS::SECRISTRdb WWS; [email protected]Fri Jan 24 1997 13:4514
    
    As it turned out this problem was caused by the fact that the
    customer had a number of people trying to execute out of accounts
    that were logged in and active but had subsequently been removed 
    from the SYSUAF.  
    
    I guess this message was an artifact of the fact that it was
    checking the UAF because it was running an external procedure,
    but since they no longer ad a UAF entry, it trapped to that
    message.  Apparently there is another case to consider ;-)
    
    Regards,
    rcs