麻烦大家帮我看看这个错误呀

[fitzanepeng1]

SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

set serveroutput off;
declare

par r_c1.part_type;
begin

par.no_fact_col := %strp_no_fact_col% ;
par.clone_fact := %strp_clone_fact%; -- Should be greater than 1 always.
par.level_of_nesting := %strp_level_of_nesting%;
par.rangepart := true; -- Should always be true as it is range or range_hash parittioned table.
par.range_hash := false;
par.total_rows := %strp_total_rows%;
par.total_rangep := %strp_total_rangep%;
par.total_subhashp :=%strp_total_subhashp%; --cnt;
par.local_index := %strp_local_index% ; --true;
par.req_local_index := %strp_req_local_index%;
par.global_range_index := %strp_global_range_index%; --true;
par.total_global_range := %strp_total_global_range%;
par.total_global_rangep := %strp_total_global_rangep%;
par.global_hash_index := %strp_global_hash_index%;
par.total_global_hash := %strp_total_global_hash%;
par.total_global_hashp := %strp_total_global_hashp%;
par.btree_index := %strp_btree_index%;
par.total_btree_index := %strp_total_btree_index%;
par.func_index := %strp_func_index%;
par.total_func_index :=%strp_total_func_index%;
par.exch_part_no := 4;
r_c1.part_proc(par);
end;
执行的时候我吧里面的变量%strp******%都替换了相应的值
但是出现了一下错误



par r_c1.part_type;
*
ERROR at line 3:
ORA-06550: line 3, column 7:
PLS-00201: identifier 'R_C1.PART_TYPE' must be declared
ORA-06550: line 3, column 7:
PL/SQL: Item ignored
ORA-06550: line 6, column 9:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 6, column 9:
PL/SQL: Statement ignored
ORA-06550: line 7, column 9:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 7, column 9:
PL/SQL: Statement ignored
ORA-06550: line 8, column 9:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 8, column 9:
PL/SQL: Statement ignored
ORA-06550: line 9, column 9:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 9, column 9:
PL/SQL: Statement ignored
ORA-06550: line 10, column 9:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 10, column 9:
PL/SQL: Statement ignored
ORA-06550: line 11, column 9:
PLS-00320:
请大家帮我看看吧
sql文件应该不会有错的，因为这是别人的sql我只是换了%%里面的内容继续跑测试。

[ngx20080110]

你的數據庫裡沒有這個r_c1包吧

[crazylaa]

[Quote=引用 1 楼 ngx20080110 的回复:]

你的數據庫裡沒有這個r_c1包吧
[/Quote]42

[sunlaji008]

[Quote=引用 1 楼 ngx20080110 的回复:]

你的數據庫裡沒有這個r_c1包吧
[/Quote]
94

[「已注销」]

汗、、、

[心中的彩虹]

[Quote=引用楼主 fitzanepeng1 的回复:]
SET ECHO ON
SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100

set serveroutput off;
declare

par r_c1.part_type;
begin

par.no_fact_col :=……
[/Quote]
你调用r_c1包的类型 是否存在 ；或者不是你当前用户创建的 有访问权限否
r_c1.part_type

[真的不知道取什么名]

--2楼3楼都是人才啊
identifier 'R_C1.PART_TYPE' must be declared
这个就是提示你说 你没有定义R_C1.PART_TYPE 这样类型