http://www.itpub.net/thread-1499223-2-1.html

13楼


任意有CREATE PROCEDURE权限的用户登录并且执行下列语句：

CREATEORREPLACEPACKAGEplch_pkgISg_stuffVARCHAR2(10):='Stuff';PROCEDUREshow_stuff;END;/CREATEORREPLACEPACKAGEBODYplch_pkgISPROCEDUREshow_stuffISBEGINDBMS_OUTPUT.put_line(g_stuff);END;END;/BEGINplch_pkg.show_stuff;END;/CREATEORREPLACEPACKAGEplch_pkgISg_new_stuffVARCHAR2(10):='NewStuff';END;/BEGINDBMS_OUTPUT.put_line(plch_pkg.g_new_stuff);END;/


下列的哪个选项正确反映了在执行上述两个匿名块之后, 我屏幕上的显示内容?

(A)
Stuff
NewStuff

(B)
First "Stuff" is displayed on the screen. Then I will see this error:
ORA-04063: package body "HR.PLCH_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "HR.PLCH_PKG"

(C)
Stuff


答案B