大侠帮助看看，这个过程为什么出错

[hansland]

大侠帮助看看，这个过程为什么出错

create or replace procedure jfsj_cust_terminal_retrv_gprs(p_gprs in varchar2)
as
gprs varchar2;

begin
gprs :=p_gprs;
select CUST_NAME,MSISDN,COUNTY,AGE,VIP_FLAG
from jfsj_cust_terminal_gl where
gprs_zc=gprs
or gprs_sy=gprs;

end jfsj_cust_terminal_retrv_gprs;

出错信息如下：

Compilation errors for PROCEDURE ZHYW.JFSJ_CUST_TERMINAL_RETRV_GPRS

Error: PLS-00215: String length constraints must be in range (1 .. 32767)
Line: 3
Text: gprs varchar2;

Error: PL/SQL: Item ignored
Line: 3
Text: gprs varchar2;

Error: PLS-00320: the declaration of the type of this expression is incomplete or malformed
Line: 6
Text: gprs :=p_gprs;

Error: PL/SQL: Statement ignored
Line: 6
Text: gprs :=p_gprs;

Error: PLS-00320: the declaration of the type of this expression is incomplete or malformed
Line: 9
Text: gprs_zc=gprs

Error: PL/SQL: SQL Statement ignored
Line: 7
Text: select CUST_NAME,MSISDN,COUNTY,AGE,VIP_FLAG

[rb41991]

你用的是什么数据库????
这样试试看!!!!
create or replace procedure jfsj_cust_terminal_retrv_gprs(p_gprs varchar(2))
define gprs varchar(2);

begin
gprs :=p_gprs;
select CUST_NAME,MSISDN,COUNTY,AGE,VIP_FLAG
from jfsj_cust_terminal_gl where
gprs_zc=gprs
or gprs_sy=gprs;

end jfsj_cust_terminal_retrv_gprs;