150楼
郫都网站建设公司成都创新互联公司,郫都网站设计制作，有大型网站制作公司丰富经验。已为郫都上千余家提供企业网站建设服务。企业网站搭建\
外贸营销网站建设要多少钱，请找那个售后服务好的
郫都做网站的公司定做！
我连接到HR用户并运行了如下语句：
CREATE TABLE plch_parts
(
partnum NUMBER
, partname VARCHAR2 (50)
)
/
BEGIN
INSERT INTO plch_parts
VALUES (1, 'Chassis');
COMMIT;
END;
/
CREATE OR REPLACE PACKAGE plch_pkg
IS
TYPE parts_t IS TABLE OF plch_parts%ROWTYPE
INDEX BY PLS_INTEGER;
PROCEDURE plch_show_parts (parts_in IN parts_t);
END;
/
CREATE OR REPLACE PACKAGE BODY plch_pkg
IS
PROCEDURE plch_show_parts (parts_in IN parts_t)
IS
BEGIN
FOR indx IN 1 .. parts_in.COUNT
LOOP
DBMS_OUTPUT.put_line (parts_in (indx).partname);
END LOOP;
END;
END;
/
GRANT SELECT ON plch_parts TO scott
/
GRANT EXECUTE ON plch_pkg TO scott
/
然后我又用SCOTT用户连接并创建了这张表：
CREATE TABLE plch_parts
(
partnum NUMBER
, partname VARCHAR2 (50)
)
/
BEGIN
INSERT INTO plch_parts
VALUES (100, 'Wheel');
COMMIT;
END;
/
下列的哪些选项包含了下列语句块的一个声明部分，从而使得这个块执行之后"Wheel"会被显示出来？
BEGIN
SELECT *
BULK COLLECT INTO l_parts
FROM plch_parts;
hr.plch_pkg.plch_show_parts (l_parts);
END;
(A)
DECLARE
TYPE parts_t IS TABLE OF plch_parts%ROWTYPE
INDEX BY PLS_INTEGER;
l_parts parts_t;
SQL> DECLARE
2 TYPE parts_t IS TABLE OF plch_parts%ROWTYPE INDEX BY PLS_INTEGER;
3
4 l_parts parts_t;
5
6 BEGIN
7 SELECT * BULK COLLECT INTO l_parts FROM plch_parts;
8
9 yoga.plch_pkg.plch_show_parts(l_parts);
10 END;
11 /
DECLARE
TYPE parts_t IS TABLE OF plch_parts%ROWTYPE INDEX BY PLS_INTEGER;
l_parts parts_t;
BEGIN
SELECT * BULK COLLECT INTO l_parts FROM plch_parts;
yoga.plch_pkg.plch_show_parts(l_parts);
END;
ORA-06550: 第 9 行, 第 3 列:
PLS-00306: 调用 'PLCH_SHOW_PARTS' 时参数个数或类型错误
ORA-06550: 第 9 行, 第 3 列:
PL/SQL: Statement ignored
SQL>
(B)
DECLARE
TYPE parts_t IS TABLE OF hr.plch_parts%ROWTYPE
INDEX BY PLS_INTEGER;
l_parts parts_t;
SQL> DECLARE
2 TYPE parts_t IS TABLE OF yoga.plch_parts%ROWTYPE INDEX BY PLS_INTEGER;
3
4 l_parts parts_t;
5
6 BEGIN
7 SELECT * BULK COLLECT INTO l_parts FROM plch_parts;
8
9 yoga.plch_pkg.plch_show_parts(l_parts);
10 END;
11 /
DECLARE
TYPE parts_t IS TABLE OF yoga.plch_parts%ROWTYPE INDEX BY PLS_INTEGER;
l_parts parts_t;
BEGIN
SELECT * BULK COLLECT INTO l_parts FROM plch_parts;
yoga.plch_pkg.plch_show_parts(l_parts);
END;
ORA-06550: 第 9 行, 第 3 列:
PLS-00306: 调用 'PLCH_SHOW_PARTS' 时参数个数或类型错误
ORA-06550: 第 9 行, 第 3 列:
PL/SQL: Statement ignored
SQL>
(C)
DECLARE
l_parts hr.plch_pkg.parts_t;
SQL> DECLARE
2 l_parts yoga.plch_pkg.parts_t;
3
4 BEGIN
5 SELECT * BULK COLLECT INTO l_parts FROM plch_parts;
6
7 yoga.plch_pkg.plch_show_parts(l_parts);
8 END;
9 /
Wheel
PL/SQL procedure successfully completed
SQL>
(D)
DECLARE
SUBTYPE parts_t IS hr.plch_pkg.parts_t;
l_parts parts_t;
SQL> DECLARE
2 SUBTYPE parts_t IS yoga.plch_pkg.parts_t;
3 l_parts parts_t;
4
5 BEGIN
6 SELECT * BULK COLLECT INTO l_parts FROM plch_parts;
7
8 yoga.plch_pkg.plch_show_parts(l_parts);
9 END;
10 /
Wheel
PL/SQL procedure successfully completed
SQL>
实测用yoga代替hr，test代替scott
答案在158楼
2011-11-16 答案CD.
%ROWTYPE是一种记录，如果你定义两个结构一模一样的记录类型，它们仍然不能够互换，会报类型不匹配的错误。
分享文章：ROWTYPE的声明与使用-创新互联
分享链接：
http://cdkjz.cn/article/dsscoc.html
