Collections:
Define Variables before Procedures and Functions in Oracle
What Is the Order of Defining Local Variables and Sub Procedures/Functions in Oracle?
✍: FYIcenter.com
In the declaration part, you must define all local variables before defining any sub procedures or sub functions. See the following sample script:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(80) := 'FYICenter'; 3 PROCEDURE WELCOME_PRINT(S CHAR) AS 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('Welcome to ' || S); 6 END; 7 BEGIN 8 WELCOME_PRINT(SITE); 9 END; 10 / SQL> EXECUTE WELCOME; Welcome to FYICenter
Notice that variable SITE should be declared before procedure WELCOME_PRINT
⇒ Formal Parameters and Actual Parameters in Oracle
⇐ Run-Away Recursive Calls in Oracle
2018-03-18, 1390🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...