这两条语句单独在sqlplus里面运行都没有问题。up!
解决方案 »
- 小城的灾难
- 父子结构序号
- 请教一个分组查询的SQL
- 在远程访问数据库时(Oracle),查询的列名为什么有重复的????
- 在ORACLE中建表时出现ORA-00922错误
- 怎么向数据类型为date的字段插入时间(hh:mm:ss)
- 怎样解决ORALCE中分页时,用count(*)来取得总记录数所耗时间过长得问题。
- 讨论:UTL_FILE包是不是只能操作服务器(ORCALE主机)上的文件?
- oracle9i初装问题,请指教!谢谢!(1)
- ****Oracle 9i 安装问题,紧急级别(一级).请诸位大侠速速帮忙.急...急...急...急...急...分可加
- 各位在ORACLE中写SQL,除了PLUS/SQL还有没有别的,这东西好差劲啊,进则有分!!
- {100分}明明表DIC_MED_FIR_LEVELa存在,但 select * from DIC_MED_FIR_LEVELa老是出错“ERROR 位于第 1 行:ORA-00942: 表或视图不存在
如str!='delete from temp_current';
EXECUTE IMMEDIATE str;以下的类似,你可以查查动态sql
CREATE OR REPLACE PROCEDURE PROCEDURE_CURRENT
后面不变
coltime_in in varchar2,
userid_in in varchar2 )
as
v_cursorID integer;
v_insertstmt varchar2(100);begin
v_cursorID := DBMS_SQL.OPEN_CURSOR;
v_insertstmt :=
'insert into temp_current select * from ccurrent3
where userid = : uin and
to_char(coldate,''yymmdd'') = : colin';
DBMS_SQL.PARSE (v_cursorID, v_insertstmt, DBMS_SQL.V7);
DBMS_SQL.BIND_VARIABLE (v_cursorID, ': uin', userid_in);
DBMS_SQL.BIND_VARIABLE (v_cursorID, ': colin', coltime_in);
DBMS_SQL.EXECUTE (v_cursorID);
DBME_SQL.CLOSE_CURSOR (v_cursorID);
exception
when others then
DBMS_SQL.CLOSE_CURSOR (v_cursorID);
raise;end; 我写成这样还是invalid,为什么?请各位指点!
as
begin
delete from temp_current;
insert into temp_current
(select * from ccurrent3
where userid = userid_in and
to_char(coldate,'yymmdd') =coltime_in); end;
(coldate_in in varchar2, userid_in in varchar2)
as
ls_sql varchar2(1000);
begin
ls_sql := 'delete from temp_current';
EXECUTE IMMEDIATE ls_sql;
commit;
insert into temp_current
select * from ccurrent3
where userid = userid_in and
to_char(coldate,'yymmdd') = coldate_in;
commit;
end;
/
和
coldate_in
?
(coltime_in in varchar2, userid_in in varchar2)
as
begin
delete from temp_current;
commit;
insert into temp_current
select * from ccurrent3
where userid = userid_in and
to_char(coldate,'yymmdd') = coldate_in;
commit;
end;
还是这么莫名其妙好了,哈哈!