Saturday 26 May 2012

Suppose a procedure proc_get_lighest_rank is stored in the user schema, user_a. How can you access the procedure within this schema? | PL SQL

 The proc_get„hlghest„rank procedure can be accessed within the user_a schema from another stored procedure. It can also be accessed either from an anonymous PL/SQL block executed on the SQL prompt logged in as user_a or directly at the SQL prompt using the EXECUTE command. In addition, it can be accessed by other users if they have the EXECUTE privilege.