Oracle - Call a Sub Procedure in Oracle

Call a Sub Procedure in Oracle

Q

How To Call a Sub Procedure in Oracle?

✍: 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

⇒Creating Oracle PL/SQL Procedures and Functions

⇒⇒Oracle Database Tutorials

2018-10-26, 691👍, 0💬

Define a Sub Procedure in Oracle
How To Define a Sub Procedure in Oracle? 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 procedure definition starts with the PROCEDURE key word. Here is... 2018-10-26, 881👍, 0💬

Call Procedure or Function Recursively in Oracle
Can Sub Procedure/Function Be Called Recursively in Oracle? 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 OR REPLACE PROCEDURE FACTORIAL_TEST AS 2 FUNCTION F... 2018-03-18, 880👍, 0💬

Call a Stored Functoin with Parameters in Oracle
How To Call a Stored Function with Parameters in Oracle? You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter: SQL> CREATE OR REPLACE FUNCTION GET_DOUBLE(X NUMBER) 2 RETURN NUMBER A... 2018-10-26, 832👍, 0💬

Call a Sub Procedure in Oracle
How To Call a Sub Procedure in Oracle? 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 ' || ... 2018-10-26, 692👍, 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.