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 Use "IN OUT" Parameter Properly
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions
✍: FYIcenter.com
Here are the rules about IN OUT parameters:
Here is good example of a procedure with IN OUT parameters:
SQL> CREATE OR REPLACE PROCEDURE SWAP_TEST AS 2 A NUMBER := 3; 3 B NUMBER := 8; 4 PROCEDURE MY_SWAP(X IN OUT NUMBER,Y IN OUT NUMBER) AS 5 T NUMBER; 6 BEGIN 7 T := X; 8 X := Y; 9 Y := T; 10 END MY_SWAP; 11 BEGIN 12 MY_SWAP(A,B); 13 DBMS_OUTPUT.PUT_LINE('A = ' || TO_CHAR(A)); 14 DBMS_OUTPUT.PUT_LINE('B = ' || TO_CHAR(B)); 15 END; 16 / SQL> EXECUTE SWAP_TEST; A = 8 B = 3
2007-04-21, 6508👍, 0💬
Popular Posts:
What is CAR (Causal Analysis and Resolution)? The basic purpose of CAR is to analyze all defects, pr...
What are database triggers? How are the triggers fired? Read this collection of questions and answer...
what is a service contract, operation contract and Data Contract? - part 1 In the below sample we ha...
How do you estimate maintenance project and change requests?
How To Retrieve the Count of Updated Rows? - Oracle DBA FAQ - Working with Database Objects in PL/SQ...