Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

How To Call a Sub Procedure?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

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('globalguideline');
8 END;
9 /

SQL> EXECUTE WELCOME;
Welcome to globalguideline


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
How To Define an Oracle Sub Procedure?How To Define a Sub Function?