create or replace procedure TEST ( to in VARCHAR2,from in VARCHAR2 ) is
begin
update tool_bus set startaddr=to where busname=from;
end TEST;
这么简单的存储过程 哪里写错了啊????????
报错如下:
Compilation errors for PROCEDURE COMMUNITY.TESTError: PLS-00103: 出现符号 "TO"在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current
Line: 1
Text: create or replace procedure TEST ( to in VARCHAR2,from in VARCHAR2 ) as
begin
update tool_bus set startaddr=to where busname=from;
end TEST;
这么简单的存储过程 哪里写错了啊????????
报错如下:
Compilation errors for PROCEDURE COMMUNITY.TESTError: PLS-00103: 出现符号 "TO"在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current
Line: 1
Text: create or replace procedure TEST ( to in VARCHAR2,from in VARCHAR2 ) as
解决方案 »
- .net 通过 commandtext=”rollback” 执行oracle回滚为何无效???????????????
- 如何实现跨平台使用Oracle和Sybase数据库?
- 能帮我解决个问题吗?
- 我在oracle的查询分析器中执行存储过程,报错了,求大师指点迷津!!
- 如何更快速的update表,求大神告知
- 请教高手一个简单问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- OLEDB for oracle驱动安装
- 求救:在线等待!imp报错:ora-00959表空间不存在!
- 建库出现错误,再现等待解决方法
- oracle spool 生成excel、csv文件的咨询
- 装了Oracle9i客户端精简版能不能装Oracle服务器?
- 排序问题
create or replace procedure TEST ( pi_to in VARCHAR2,pi_from in VARCHAR2 ) is
begin
update tool_bus set startaddr=pi_to where busname=pi_from;
end TEST;