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
⇒ Use "IN OUT" Parameters in Oracle
⇐ Use "IN" Parameters in Oracle
2018-10-19, 2176🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...