回答編集履歴
3
修正
answer
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
BEGIN
|
|
12
12
|
EXECUTE PACKAGE1.PROCEDURE2(PARAMETER1, PARAMETER2) ;
|
|
13
13
|
DBMS_OUTPUT.PUT_LINE('PARAMETER1:' || PARAMETER1) ;
|
|
14
|
-
DBMS_OUTPUT.PUT_LINE('PARAMETER2:' ||
|
|
14
|
+
DBMS_OUTPUT.PUT_LINE('PARAMETER2:' || PARAMETER2) ;
|
|
15
15
|
END ;
|
|
16
16
|
/
|
|
17
17
|
```
|
2
追記
answer
CHANGED
|
@@ -10,8 +10,8 @@
|
|
|
10
10
|
PARAMETER2 VARHCAR2(1024) ;
|
|
11
11
|
BEGIN
|
|
12
12
|
EXECUTE PACKAGE1.PROCEDURE2(PARAMETER1, PARAMETER2) ;
|
|
13
|
-
|
|
13
|
+
DBMS_OUTPUT.PUT_LINE('PARAMETER1:' || PARAMETER1) ;
|
|
14
|
-
|
|
14
|
+
DBMS_OUTPUT.PUT_LINE('PARAMETER2:' || PARAMETER) ;
|
|
15
15
|
END ;
|
|
16
16
|
/
|
|
17
17
|
```
|
1
追記
answer
CHANGED
|
@@ -3,5 +3,16 @@
|
|
|
3
3
|
|
|
4
4
|
[EXECUTE](https://docs.oracle.com/cd/E82638_01/SQPUG/EXECUTE.htm#GUID-A64F29C8-B5C7-426D-82E9-A8E85763F3D6)
|
|
5
5
|
|
|
6
|
+
```PL/SQL
|
|
7
|
+
SET SERVEROUTOUT ON
|
|
8
|
+
DECLARE
|
|
6
|
-
|
|
9
|
+
PARAMETER1 VARHCAR2(1024) ;
|
|
10
|
+
PARAMETER2 VARHCAR2(1024) ;
|
|
11
|
+
BEGIN
|
|
7
|
-
EXECUTE PACKAGE1.
|
|
12
|
+
EXECUTE PACKAGE1.PROCEDURE2(PARAMETER1, PARAMETER2) ;
|
|
13
|
+
DBMSOUTPUT.PUTLINE('PARAMETER1:' || PARAMETER1) ;
|
|
14
|
+
DBMSOUTPUT.PUTLINE('PARAMETER2:' || PARAMETER) ;
|
|
15
|
+
END ;
|
|
16
|
+
/
|
|
17
|
+
```
|
|
18
|
+
PL/SQL入門書を1冊買って勉強されては？
|