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, 6581👍, 0💬
Popular Posts:
How To Remove the Top White Space of Your Web Page? - CSS Tutorials - Introduction To CSS Basics The...
Which JavaScript file is referenced for validating the validators at the client side ? WebUIValidati...
What is SMC approach of estimation?
Does it matter in what order catch statements for FileNotFoundException and IOExceptipon are written...
What will be printed as the result of the operation below: main() { char s1[]="Cisco"; char s2[]="sy...