How To Execute A Stored Procedure?

1.	How To Execute A Stored Procedure?
Answer» If you WANT to execute a STORED procedure, you can use the EXECUTE statement. The EXAMPLE script below shows how to executes a stored procedure: SQL&GT; set serveroutput on; SQL> CREATE PROCEDURE Greeting AS BEGIN DBMS_OUTPUT.PUT_LINE('Welcome to wisdom!'); END; / Procedure created. SQL> EXECUTE Greeting; Welcome to wisdom! If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: Procedure created. SQL> EXECUTE Greeting; Welcome to wisdom!

Answer»

If you WANT to execute a STORED procedure, you can use the EXECUTE statement. The EXAMPLE script below shows how to executes a stored procedure:

SQL&GT; set serveroutput on; SQL> CREATE PROCEDURE Greeting AS BEGIN DBMS_OUTPUT.PUT_LINE('Welcome to wisdom!'); END; /

Procedure created. SQL> EXECUTE Greeting; Welcome to wisdom!

If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure:

Procedure created. SQL> EXECUTE Greeting; Welcome to wisdom!

Discussion