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, 1382🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...