How to execute a Procedure?


******************************
Using SQL command Promt:

Execute  PROCEDURE_NAME [(Parameters)];

EXEC PROCEDURE_NAME [(Parameters)];

********
Example:
execute hello;

******************************
Execute from a PL/SQL Program

BEGIN
    PROCEDURE_NAME [(Parameters)];
END;

*******
EXAMPLE:

BEGIN
HELLO;
END; 
***********************************
Previous
Next Post »