存储过程包含这一句
select count(*)
into ucount
from t_user u
where u.user_id = v_user_id
and u.user_status = 0;
将0换成constants.c_t_user_normal时就报错ORA-06508: PL/SQL: 无法在调用之前找到程序单元
包的定义如下:
CREATE OR REPLACE PACKAGE CONSTANTS
as
--definition of user_status in t_user;
/*
0 Õý³£
1 µ¥ÏòÍ£»ú
2 Í£»ú
3 Ô¤Ïú»§
4 Ïú»§
5 ¹ý»§
6 ¸ÄºÅ
*/
c_t_user_normal binary_integer :=0;
c_t_user_onesidestop binary_integer :=1;
c_t_user_stop binary_integer :=2;
c_t_user_pre_unregistered binary_integer :=2;
c_t_user_unregistered binary_integer:=3;
c_t_user_unregiseredaccount binary_integer:=4;
c_t_user_transferaccount binary_integer:=5;
c_t_user_changeno binary_integer:=6;
--define the service type
c_album number:=1;
c_flash number:=2;
c_video number:=3;
END CONSTANTS;
请问时什么原因?
select count(*)
into ucount
from t_user u
where u.user_id = v_user_id
and u.user_status = 0;
将0换成constants.c_t_user_normal时就报错ORA-06508: PL/SQL: 无法在调用之前找到程序单元
包的定义如下:
CREATE OR REPLACE PACKAGE CONSTANTS
as
--definition of user_status in t_user;
/*
0 Õý³£
1 µ¥ÏòÍ£»ú
2 Í£»ú
3 Ô¤Ïú»§
4 Ïú»§
5 ¹ý»§
6 ¸ÄºÅ
*/
c_t_user_normal binary_integer :=0;
c_t_user_onesidestop binary_integer :=1;
c_t_user_stop binary_integer :=2;
c_t_user_pre_unregistered binary_integer :=2;
c_t_user_unregistered binary_integer:=3;
c_t_user_unregiseredaccount binary_integer:=4;
c_t_user_transferaccount binary_integer:=5;
c_t_user_changeno binary_integer:=6;
--define the service type
c_album number:=1;
c_flash number:=2;
c_video number:=3;
END CONSTANTS;
请问时什么原因?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9375/viewspace-555060/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9375/viewspace-555060/