Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Call a Sub Procedure
How To Call a Sub Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
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, 7811👍, 0💬
Popular Posts:
An application needs to load a library before it starts to run, how to code? One option is to use a ...
How To Run "mysql" Commands from a Batch File? - MySQL FAQs - Command-Line End User Interface mysql ...
What is the difference between include directive & jsp:include action? Difference between includ...
Can an anonymous class be declared as implementing an interface and extending a class? An anonymous ...
it will be very helpful if you send some important Questions with Answers of DBMS Tell us what types...