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, 1770🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...