Collections:
Pass Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle?
✍: FYIcenter.com
Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this:
SQL> CREATE OR REPLACE PROCEDURE DBA_TASK (day VARCHAR2) AS 2 BEGIN 3 IF day = 'MONDAY' THEN 4 DBMS_OUTPUT.PUT_LINE('Checking log files.'); 5 ELSIF day = 'FRIDAY' THEN 6 DBMS_OUTPUT.PUT_LINE('Rebuild indexes.'); 7 ELSE 8 DBMS_OUTPUT.PUT_LINE('Reading some papers.'); 9 END IF; 10 END; 11 / SQL> EXECUTE DBA_TASK('MONDAY'); Checking log files. SQL> EXECUTE DBA_TASK('SUNDAY'); Reading some papers.
As you can see, procedures with parameters can make procedures more flexible.
⇒ Create a Stored Function in Oracle
⇐ Drop a Stored Procedure in Oracle
2018-11-11, 1699🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...