Oracle - Execute a Stored Procedure in Oracle

Execute a Stored Procedure in Oracle

Q

How To Execute a Stored Procedure in Oracle?

✍: FYIcenter.com

A

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> set serveroutput on;

SQL> CREATE PROCEDURE Greeting AS
  2  BEGIN
  3    DBMS_OUTPUT.PUT_LINE('Welcome to FYICenter!');
  4  END;
  5  /
Procedure created.

SQL> EXECUTE Greeting;
Welcome to FYICenter!

⇒Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2018-11-11, 380👍, 0💬

Popular Posts:

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

CONVERT() - Formatti...

How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...

OUTPUT - Defining Ou...

How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored p...

AdventureWorksLT - D...

How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...