Basic Oracle Concepts and Programming Question:

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) := 'globalguideline';
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 globalguideline

Notice that variable SITE should be declared before procedure WELCOME_PRINT