Quick Search:
 
 The Oracle EXECUTE Procedure      [Return To Index] Jump to:  

Term: EXECUTE

Definition:
EXECUTE is a built-in Oracle procedure which is used to run a statement and direct its output to a message buffer. Note that EXECUTE is a SQL* Plus command. It is similar to executing a statement in an anonymous PL/SQL block.

Example Usage:

The SQL command line statement below executes DBMS_OUTPUT.PUT_LINE to display '100'.

SQL> EXECUTE DBMS_OUTPUT.PUT_LINE(100);
100

PL/SQL procedure successfully completed.


The EXECUTE statement below runs the stored procedure 'P_GET_SAL' to get the salary of an employee from the EMPLOYEE table. Note that G_SAL is a bind variable used to capture the OUT parameter data of the procedure.

SQL> VAR G_SAL NUMBER;
SQL> EXECUTE P_GET_SAL(100,:G_SAL);

PL/SQL procedure successfully completed.

SQL> PRINT :G_SAL;
2300


Note that EXECUTE is an Object privilege. If a user BOB seeks to execute a procedure whose owner is JANE, then JANE must grant the execute privilege on the procedure to BOB. For example, to grant the EXECUTE privilege for the procedure 'SPECIAL_PROC' to BOB:

SQL> GRANT EXECUTE ON SPECIAL_PROC TO BOB;

Grant succeeded.


Related Links:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org