Collections:
Use "OUT" Parameters in Oracle
How To Use "OUT" Parameter Properly in Oracle?
✍: FYIcenter.com
Here are the rules about OUT parameters:
Here is good example of a procedure with an OUT parameter:
SQL> CREATE OR REPLACE PROCEDURE WELCOME AS 2 SITE CHAR(40) := 'FYICenter.com'; 3 MESSAGE CHAR(80); 4 PROCEDURE WELCOME_PRINT(S IN CHAR, M OUT CHAR) AS 5 BEGIN 6 M := 'Welcome to ' || S; 7 END; 8 BEGIN 9 WELCOME_PRINT('MySpace.com', MESSAGE); 10 DBMS_OUTPUT.PUT_LINE(MESSAGE); 11 WELCOME_PRINT(SITE, MESSAGE); 12 DBMS_OUTPUT.PUT_LINE(MESSAGE); 13 END; 14 / SQL> EXECUTE WELCOME; Welcome to MySpace.com Welcome to FYICenter.com
2018-10-19, 969👍, 0💬
Popular Posts:
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...