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 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, 8065👍, 0💬
Popular Posts:
What is page thrashing? Some operating systems (such as UNIX or Windows in enhanced mode) use virtua...
What is the difference between strings and character arrays? A major difference is: string will have...
From performance point of view how do they rate ? Repeater is fastest followed by Datalist and final...
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
What's the output of the following program? And why? #include main() { typedef union { int a; char b...