大侠帮助看看,这个过程为什么出错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_GPRSError: 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=gprsError: PL/SQL: SQL Statement ignored
Line: 7
Text: select CUST_NAME,MSISDN,COUNTY,AGE,VIP_FLAG
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_GPRSError: 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=gprsError: PL/SQL: SQL Statement ignored
Line: 7
Text: select CUST_NAME,MSISDN,COUNTY,AGE,VIP_FLAG
解决方案 »
- oracle10g存储过程的问题
- 问句SQL语句
- oracle 分组汇总,请高手指点啊
- ---------------------oracle 2304錯誤---------------------
- oracle10g用浏览器访问OEM的时候报错,怎么解决?
- 哪位朋友有oracle9i 中文版 FOR WINDOWS的,请帮帮我,很需要!
- 各位帮忙看看这SQL脚本有什么蹊跷之处?
- 急!!!请问Oracle存储过程中如何执行一个字符串变量(例如在SQL SERVER中可以使用exec @s)
- 用什么类型的字段,varchar2不够长
- ora-00942:表和视图不存在?(在线等你的答案!)
- 在windows操作系统环境下,如何设置oracle?高手请进……
- 求ORACLE数据库的备份与恢复方法或命令,来着有分!!!
gprs varchar2(10);指定长度