I'm trying to figure out the difference as to why the Command Window shows the code being compiled in one situation but not the other. To illustrate. If I paste the each command into the Command Window one at a time I get
==========================================================
SQL> @//my_pkg_num_one
Package created
Package body created
SQL> @//my_pkg_num_two
Package created
Package body created
==========================================================
If instead I copy those two lines and paste both into the Command Window at the same time (the copy/paste buffer would contain)
@//my_pkg_num_one
@//my_pkg_num_two
I instead see
==========================================================
SQL> @//my_pkg_num_one.sql
SQL> CREATE OR REPLACE PACKAGE my_pkg_num_one
2 AUTHID DEFINER
3 IS
4
5
6 k_version CONSTANT VARCHAR2(10) := '1.00';
7
8 FUNCTION f_get_version RETURN VARCHAR2;
9
10 END my_pkg_num_one;
11 /
Package created
SQL> CREATE OR REPLACE PACKAGE BODY my_pkg_num_one IS
2
3 FUNCTION f_Get_Version RETURN VARCHAR2 IS
4 BEGIN
5 RETURN k_Version;
6 END f_Get_Version;
7
8 END my_pkg_num_one;
9 /
Package body created
SQL> @//my_pkg_num_two.sql
SQL> CREATE OR REPLACE PACKAGE my_pkg_num_two
2 AUTHID DEFINER
3 IS
4
5
6 k_version CONSTANT VARCHAR2(10) := '1.00';
7
8 FUNCTION f_get_version RETURN VARCHAR2;
9
10 END my_pkg_num_two;
11 /
Package created
SQL> CREATE OR REPLACE PACKAGE BODY my_pkg_num_two IS
2
3 FUNCTION f_Get_Version RETURN VARCHAR2 IS
4 BEGIN
5 RETURN k_Version;
6 END f_Get_Version;
7
8 END my_pkg_num_two;
9 /
Package body created
==========================================================
How do I make the second situation, pasting of two commands at once, simply show
==========================================================
Package created
Package body created
==========================================================
for each package instead of the code?
This was produced in both 12.0.6.1835 and 7.1837
Using
Home:
DLL: c:\Oracle\instantclient_12_1\oci.dll
OCI: version 12.1 (12.1.0.2.0)
I've done this against both an 11.2.0.4.0 and 12.1.0.2.0 DB.
==========================================================
SQL> @//my_pkg_num_one
Package created
Package body created
SQL> @//my_pkg_num_two
Package created
Package body created
==========================================================
If instead I copy those two lines and paste both into the Command Window at the same time (the copy/paste buffer would contain)
@//my_pkg_num_one
@//my_pkg_num_two
I instead see
==========================================================
SQL> @//my_pkg_num_one.sql
SQL> CREATE OR REPLACE PACKAGE my_pkg_num_one
2 AUTHID DEFINER
3 IS
4
5
6 k_version CONSTANT VARCHAR2(10) := '1.00';
7
8 FUNCTION f_get_version RETURN VARCHAR2;
9
10 END my_pkg_num_one;
11 /
Package created
SQL> CREATE OR REPLACE PACKAGE BODY my_pkg_num_one IS
2
3 FUNCTION f_Get_Version RETURN VARCHAR2 IS
4 BEGIN
5 RETURN k_Version;
6 END f_Get_Version;
7
8 END my_pkg_num_one;
9 /
Package body created
SQL> @//my_pkg_num_two.sql
SQL> CREATE OR REPLACE PACKAGE my_pkg_num_two
2 AUTHID DEFINER
3 IS
4
5
6 k_version CONSTANT VARCHAR2(10) := '1.00';
7
8 FUNCTION f_get_version RETURN VARCHAR2;
9
10 END my_pkg_num_two;
11 /
Package created
SQL> CREATE OR REPLACE PACKAGE BODY my_pkg_num_two IS
2
3 FUNCTION f_Get_Version RETURN VARCHAR2 IS
4 BEGIN
5 RETURN k_Version;
6 END f_Get_Version;
7
8 END my_pkg_num_two;
9 /
Package body created
==========================================================
How do I make the second situation, pasting of two commands at once, simply show
==========================================================
Package created
Package body created
==========================================================
for each package instead of the code?
This was produced in both 12.0.6.1835 and 7.1837
Using
Home:
DLL: c:\Oracle\instantclient_12_1\oci.dll
OCI: version 12.1 (12.1.0.2.0)
I've done this against both an 11.2.0.4.0 and 12.1.0.2.0 DB.
