How To Call a Sub Procedure

Q

How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions

✍: FYIcenter.com

A

To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure:

SQL> CREATE OR REPLACE PROCEDURE WELCOME AS       
  2    PROCEDURE WELCOME_PRINT(S CHAR) AS      
  3    BEGIN         
  4      DBMS_OUTPUT.PUT_LINE('Welcome to ' || S);  
  5    END;          
  6  BEGIN           
  7    WELCOME_PRINT('FYICenter');            
  8  END;            
  9  /

SQL> EXECUTE WELCOME;
Welcome to FYICenter

2007-04-25, 8937👍, 0💬

How To Define a Sub Function
How To Define a Sub Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A sub function is a function defined and used inside another procedure or function. You need to define a sub function in the declaration part of the enclosing procedure or function. Sub function defini... 2007-04-25, 8863👍, 0💬

What Is the Difference between Formal Parameters and Actual Parameters
What Is the Difference between Formal Parameters and Actual Parameters? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Formal parameter and actual parameter are two different terms related parameters used in the procedures and functions: A formal parameter is a term used to ref... 2007-04-25, 8077👍, 0💬

Can Sub Procedure/Function Be Called Recursively
Can Sub Procedure/Function Be Called Recursively? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions PL/SQL allows sub procedures or functions to be called recursively. The tutorial example below shows you how to calculate factorial values with a recursive sub function: SQL> CREATE... 2007-04-25, 7341👍, 0💬

How To Define a Sub Procedure
How To Define a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A sub procedure is a named procedure defined and used inside another procedure or function. You need to define a sub procedure in the declaration part of the enclosing procedure or function. Sub proce... 2007-04-25, 6088👍, 0💬

What Is the Order of Defining Local Variables and Sub Procedures/Functions
What Is the Order of Defining Local Variables and Sub Procedures/Functions? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions In the declaration part, you must define all local variables before defining any sub procedures or sub functions. See the following sample script: SQL> CRE... 2007-04-25, 6003👍, 0💬

What Happens If Recursive Calls Get Out of Control
What Happens If Recursive Calls Get Out of Control? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions What happens if your code has bug on recursive procedure calls, which causes an infinite number nested procedure calls? The answer is so good. Oracle server seems to offer no prot... 2007-04-25, 5841👍, 0💬

How To Call a Stored Function
How To Call a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A stored function can be called as part of expression in any PL/SQL statement. One simplest way to call a stored function is to a dummy SELECT statement as shown in the following tutorial script using... 2007-04-26, 5721👍, 0💬

How To Create a Stored Function
How To Create a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A stored function is a function with a specified name and stored into the current database. If you want to create a stored function, you can use the CREATE FUNCTION statement. The example script bel... 2007-04-26, 5523👍, 0💬

How To Drop a Stored Function
How To Drop a Stored Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions If there is an existing stored function and you don't want it any more, you can remove it from the database by using the DROP FUNCTION statement as shown in the following script example: SQL> CREATE O... 2007-04-25, 5498👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.