在sql*puls下执行以下:declare
v_rc pkg_test.myrctype;
v_data oanotice%rowtype;
begin
query(v_rc);
fetch v_rc into v_data;
loop
exit when v_rc%notfound;
dbms_output.put_line(v_date.col_name||' '||.....);
fetch v_rc into v_data;
end loop;
close v_rc;
end;
/
v_rc pkg_test.myrctype;
v_data oanotice%rowtype;
begin
query(v_rc);
fetch v_rc into v_data;
loop
exit when v_rc%notfound;
dbms_output.put_line(v_date.col_name||' '||.....);
fetch v_rc into v_data;
end loop;
close v_rc;
end;
/
ORA-06550: 行9、列22:
PLS-00201: 必须说明标识符'V_DATE.SUBJECT'
ORA-06550: 行9、列1:
PL/SQL: Statement ignored
oanotice表中有一列名为a,那么以下表示:
dbms_output.put_line(v_date.a);
desc oanotice
列名 空? 类型
------------------------------ -------- ----
SENTDATE DATE
SUBJECT VARCHAR2(50)
CONTENT LONG
SENDER VARCHAR2(20)SQLWKS> declare
2> v_rc pkg_test.myrctype;
3> v_data oanotice%rowtype;
4> begin
5> query(v_rc);
6> fetch v_rc into v_data;
7> loop
8> exit when v_rc%notfound;
9> dbms_output.put_line(v_date.subject||v_date.content||v_date.sender);
10> fetch v_rc into v_data;
11> end loop;
12> close v_rc;
13> end;
14> /
dbms_output.put_line(v_date.subject||v_date.content||v_date.sender);
*
ORA-06550: 行9、列22:
PLS-00201: 必须说明标识符'V_DATE.SUBJECT'
ORA-06550: 行9、列1:
PL/SQL: Statement ignored
dbms_output.put_line(v_data.subject||v_data.content||v_data.sender);