Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Define a Procedure inside Another Procedure
How To Define a Procedure inside Another Procedure? - Oracle DBA FAQ - Introduction to PL/SQL
✍: FYIcenter.com
Define a procedure inside another procedure is supported by PL/SQL. The following tutorial script shows you an example:
SQL> CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS 2 PROCEDURE DBA_TASK (day VARCHAR2) AS 3 BEGIN 4 IF day = 'MONDAY' THEN 5 DBMS_OUTPUT.PUT_LINE('Checking log files.'); 6 ELSIF day = 'FRIDAY' THEN 7 DBMS_OUTPUT.PUT_LINE('Rebuild indexes.'); 8 ELSE 9 DBMS_OUTPUT.PUT_LINE('Reading some papers.'); 10 END IF; 11 END; 12 BEGIN 13 DBA_TASK('MONDAY'); 14 DBA_TASK('TUESDAY'); 15 END; 16 / SQL> EXECUTE DBA_WEEK; Checking log files. Reading some papers.
Remember that procedures used inside a procedure must be defined in the declaration block.
2007-04-26, 4749👍, 0💬
Popular Posts:
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...