January 7, 2009 06:37pm pst

1. virdi_ds 4,500
2. markgeer 4,486
3. sujith80 3,950
4. dbmullen 3,100
5. sdstuber 2,000
5. flow01 2,000
5. St3veMax 2,000
5. jabcoco 2,000
9. nav_kum_v 1,800
10. dvz 1,675
11. k_murli_... 1,400
12. arnold 1,200
13. mlmcc 1,000
13. johnsmith... 1,000
15. mohamma... 750
16. evgenyg 675
17. MikeOM_... 500
17. dportas 500
19. fsze88 380
20. ajexpert 200
21. kelvinwkw 172
21. gatorvip 172
21. shajukg 172
24. angelIII 150
25. woolmilkp... 136
25. sstad 136

1. schwertner 2,978,704
2. markgeer 1,335,187
3. angelIII 1,191,483
4. seazodiac 1,054,253
5. paquicuba 905,541
6. sdstuber 894,440
7. sujith80 831,802
8. DrSQL 817,586
9. slightwv 799,996
10. rbrooker 579,078
11. ram_0218 526,239
12. johnsone 524,766
13. nav_kum_v 457,035
14. andrewst 421,039
15. actonwang 391,037
16. sathyagiri 388,161
17. MohanKN... 351,476
18. MikeOM_... 347,904
19. jrb1 343,052
20. awking00 334,691
21. anand_2... 331,471
22. GGuzdziol 302,666
23. Henka 268,396
24. RCorfman 266,355
25. jinesh_ka... 261,604

05.30.2004 at 10:46PM PDT, ID: 21007659

	[x] Attachment Details

Referring to package content

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.6

Zone:

Oracle Database

Tags:

package, referring, body

Is the following possible in PL/SQL?

SQL> CREATE OR REPLACE PACKAGE const_pkg
2 AS
3 var1 CONSTANT VARCHAR2(11) := 'MY_CONSTANT';
4 END const_pkg;
5 /

Package created.

SQL> CREATE OR REPLACE PACKAGE work_pkg
2 AS
3 PROCEDURE p;
4 END work_pkg;
5 /

Package created.

CREATE OR REPLACE PACKAGE BODY work_pkg
AS
PROCEDURE p
IS
var1 CONSTANT VARCHAR2(11) := 'work_pkg';
BEGIN
USING const_pkg --Please refer to this line
case var1 -- var1 is there in both const_pkg and work_pkg
When 'const_pkg' then
DBMS_OUTPUT.PUT_LINE('This var is in const_pkg');
When 'work_pkg' then
DBMS_OUTPUT.PUT_LINE('This var is in work_pkg');
END case;
END p;
END work_pkg;

and this code should output const_pkg.

Please look at the statement
"USING const_pkg"

This should make parser to refer all the variables defined under the block to be available in package 'const_pkg'.
I hope this kind of functionality is in some other programming language (may be pascal)

#	Title
1	DBMS_STAT
2	dbms_xslprocessor.valueOf results i…
3	pl/sql procedures or pkg --
4	PROC_PKGS_KEEP
5	How to convert CLOB to VARCHAR2 …
6	ORA-04067: not executed, pac…