提示错误Error(29,129): PLS-00103: Encountered the symbol "(" when expecting one of the following: ) varying large create or replace PROCEDURE sp_hw_BCCreate8ByteString
(
v_psInputStr CHAR ,
v_psFieldStr CHAR ,
v_psOutputStr OUT CHAR,
piReturnCode OUT INTEGER
)AS
l_error CHAR( 5) := '00000';
v_iLoop INTEGER ;
v_sChar CHAR( 1);
v_sCharInField CHAR( 1);
BEGIN
v_psOutputStr := '00000000';
v_iLoop := 1;
WHILE v_iLoop <= 8 LOOP
v_sChar := SUBSTR(v_psInputStr,v_iLoop,1);
v_sCharInField := SUBSTR(v_psFieldStr,v_iLoop,1);
IF ( v_sChar = '?' ) THEN
v_sChar := v_sCharInField;
ELSE
IF ( v_sChar <> '0' AND v_sChar <> '1' ) THEN
piReturnCode := -1;
RETURN ;--warning:oracle procedure can't return a value -1;
END IF ;
END IF ;
v_psOutputStr := CAST(CONCAT(CONCAT(SUBSTR(v_psOutputStr,1,v_iLoop),v_sChar),SUBSTR(v_psOutputStr,v_iLoop+1+1)) AS CHAR( 9));
v_iLoop := v_iLoop + 1;
END LOOP ;
piReturnCode := 0;
RETURN ;--warning:oracle procedure can't return a value (0);
END sp_hw_BCCreate8ByteString ;
(
v_psInputStr CHAR ,
v_psFieldStr CHAR ,
v_psOutputStr OUT CHAR,
piReturnCode OUT INTEGER
)AS
l_error CHAR( 5) := '00000';
v_iLoop INTEGER ;
v_sChar CHAR( 1);
v_sCharInField CHAR( 1);
BEGIN
v_psOutputStr := '00000000';
v_iLoop := 1;
WHILE v_iLoop <= 8 LOOP
v_sChar := SUBSTR(v_psInputStr,v_iLoop,1);
v_sCharInField := SUBSTR(v_psFieldStr,v_iLoop,1);
IF ( v_sChar = '?' ) THEN
v_sChar := v_sCharInField;
ELSE
IF ( v_sChar <> '0' AND v_sChar <> '1' ) THEN
piReturnCode := -1;
RETURN ;--warning:oracle procedure can't return a value -1;
END IF ;
END IF ;
v_psOutputStr := CAST(CONCAT(CONCAT(SUBSTR(v_psOutputStr,1,v_iLoop),v_sChar),SUBSTR(v_psOutputStr,v_iLoop+1+1)) AS CHAR( 9));
v_iLoop := v_iLoop + 1;
END LOOP ;
piReturnCode := 0;
RETURN ;--warning:oracle procedure can't return a value (0);
END sp_hw_BCCreate8ByteString ;
解决方案 »
- 关于weblogic的数据源布置问题
- ●█〓oracle里写个存储过程报“创建的过程带有编译错误”〓█●
- 统计下层子孙数量
- Oracle 查询语句
- Oracle数据初始化问题!
- 保留字段
- linux oracle 8.17 启动listener出错,谢谢大家啦。晕,,TNS-12545: Connect failed because target host or object does not exist
- 请教关于oracle问题
- 敬请各位大虾 急救!! 在windows xp下安装oracle9i到99%系统配置时通不过怎么办??
- ORACLE 沒有自動COMMIT?
- 如何一次将表中的数据都取出来。
- 如何在PL/SQL中存取long raw字段?PL中的long raw变量只有32760字节不够长啊
v_psOutputStr := CAST(CONCAT(CONCAT(SUBSTR(v_psOutputStr,1,v_iLoop),v_sChar),SUBSTR(v_psOutputStr,v_iLoop+1+1)) AS CHAR( 9)); ====>select CAST(CONCAT(CONCAT(SUBSTR(v_psOutputStr,1,v_iLoop),v_sChar),SUBSTR(v_psOutputStr,v_iLoop+1+1)) AS CHAR( 9))
into v_psOutputStr
from dual;