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, 1371🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...