菜鸟求助...

[tobehungry]

有一个存储过程
procedure term_read_terminfo(caWsId in char,OutPut out char)
as
t1_row terminfo%rowtype;
begin
select * into t1_row from terminfo where termno=caWsId;

OutPut:= NVL(t1_row.termno,' ')||NVL(t1_row.teller_id,' ')||NVL(t1_row.inst_cd,' ')||NVL(t1_row.regn_cd,' ')
||NVL(t1_row.ugrp_cd,' ')||NVL(t1_row.locn_cd,' ')||NVL(t1_row.modl_cd,' ')||NVL(t1_row.verno,' ')
||NVL(t1_row.pinfmt,' ')||NVL(t1_row.term_type,' ')||NVL(t1_row.time_offset,' ')||NVL(t1_row.buss_allow,' ')
||NVL(t1_row.modifydate,' ');

EXCEPTION WHEN NO_DATA_FOUND THEN
OutPut := 'n'; --termno not found
end;

我在sqlplus里面输入
declare
2 a char(16);
3 b char(200);
4 begin
5 a:='015T1';
6 exec term_read_terminfo(a,b);
7 DBMS_OUTPUT.PUT_LINE(b);
8 end;
9 /
结果报错了
ERROR at line 6:
ORA-06550: line 6, column 6:
PLS-00103: Encountered the symbol "TERM_READ_TERMINFO" when expecting one of the following:
:= . ( @ % ;


我找不到原因,求知情人指点我怎么做才能在sqlplus中给存储过程输入参数并且打印出调用结果,另外这个存储过程写的有问题吗?

[xkx2003]

带返回值的，楼主可以使用函数

把过程改成函数
然后在sqlplus里面直接
exec term_read_terminfo('015T1');

[tobehungry]

......this procedure is writed by other people,I can use it,but can't change it.

[wfqqwer5213]

去掉exec